[web2py] Re: postgres - prepared statements in DAL?

2011-08-03 Thread Tarun Arora
We have lots of queries where we only need to change variables( bind parameters) and I was thinking of using prepared statements as it is recommended way for optimize performance to avoid over ahead costs of planning, parsing by query analyzer each time query is executed. 2-phase commit it not

[web2py] Re: postgres - prepared statements in DAL?

2011-08-03 Thread Massimo Di Pierro
No. Can you give us an example of why you should use it outside a distributed transaction? On Aug 3, 6:31 am, Tarun Arora wrote: > Is it possible to create and execute prepared statements in DAL for > postgresql?  I observed there is a prepare api for creating 'PREPARE > TRANSACTIONS' for two-pha