Re: Stored procedures returning rowsets
От | Jaroslaw Nozderko |
---|---|
Тема | Re: Stored procedures returning rowsets |
Дата | |
Msg-id | 250B3114DA16D511B82C00E0094005F809B84913@MSGWAW11 обсуждение исходный текст |
Ответ на | Stored procedures returning rowsets (Jarosław Nozderko <jaroslaw.nozderko@polkomtel.com.pl>) |
Ответы |
Re: Stored procedures returning rowsets
|
Список | pgsql-general |
Hi Mark, > > Previously > > >Perhaps not all these factors are always important, but in big and > >heavy loaded systems it's really unimaginable to send "raw" queries. > > Interesting, > > I have heard this often... mainly from SQL Server folk.... > I find it hard to understand what is bad about "raw" sql.... > here is why : > > As I understand it, every query goes through the stages of > parse,execute, [and possibly fetch(es)]. I think there is also plan/optimize stage between parse and execute... And it may be expensive. Another advantage of stored procedures is possibility of encapsulating business logic on server side only. Regards, Jarek Jaroslaw Nozderko GSM +48 601131870 / Kapsch (22) 6075013 jaroslaw.nozderko@polkomtel.com.pl IT/CCBS/RS - Analyst Programmer
В списке pgsql-general по дате отправления: