NYCPHP Meetup

NYPHP.org

[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