[nycphp-talk] application logic in stored procedures
joshmccormack at travelersdiary.com
joshmccormack at travelersdiary.com
Fri Nov 7 11:28:38 EST 2003
On Fri, 7 Nov 2003, Hans Zaunere wrote:
>
>
> felix zaslavskiy wrote:
> > how people made decisions on wheather they needed stored procedures
> > on basis of their project requirements.
>
> It's a tough call. I still have not been romanced by PGSQL, but certainly see it's value. As a side note, we'll be having a great presentation on PGSQL from one of the core developers in Jan or Feb.
>
> H
The performance of stored procedures over regular queries can be substantial. I'd recommend writing up a typical query as a stored procedure and run a benchmark. Then put it into your app and try it, and see if there's a noticeable difference.
Josh
More information about the talk
mailing list