Re: [GENERAL] about speed
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] about speed |
Дата | |
Msg-id | Pine.LNX.4.20.9911261437450.344-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | about speed ("Vovk G. Grigoriy" <vovk@sled.rpa.ryazan.su>) |
Список | pgsql-general |
On 1999-11-25, Vovk G. Grigoriy mentioned: > Can any tell my, what will fastly - "SELECT ..." statement or function > doing "SELECT..."? I am not sure, but it would seem that a function doing SELECT will do just that: call SELECT. The only difference you would have is the function call overhead. I'm not sure though to what extent the SQL in the function is preparsed, but in general I never have seen this mentioned as a performance-tuning measure. > I do query whith storage procedure in MS SQL, and what about postgresql? We have user-defined functions, which cover some areas of stored procedures, but not others. For example, functions can not return a set of tuples. There are "stored procedure" threads all the time on these mailing lists -- you are encouraged to look through them for the detailed answers. Also, some of those things are being worked on for 7.0. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-general по дате отправления: