[nycphp-talk] application logic in stored procedures
John Lacey
jlacey at att.net
Fri Nov 7 11:54:23 EST 2003
and don't forget, there's a PlPHP procedural language for PostgreSQL,
albeit beta...
http://www.commandprompt.com/index.lxp?lxpt=22
it's not ready for prime time, but it's nice to know there's activity here.
John
joshmccormack at travelersdiary.com wrote:
> 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
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
>
More information about the talk
mailing list