Re: [GENERAL] Prepared queries vs Non-prepared

2007-03-28 Thread Richard Huxton
Denis Gasparin wrote: Hi! I am testing the PHP PDO library versus the old style PHP postgres functions. I noted that PDO library declare and prepare every statement. I mean: $s = $db->query("select * from test where field=1"); is equivalent to $s = $db->prepare("select * from test where field

[GENERAL] Prepared queries vs Non-prepared

2007-03-28 Thread Denis Gasparin
Hi! I am testing the PHP PDO library versus the old style PHP postgres functions. I noted that PDO library declare and prepare every statement. I mean: $s = $db->query("select * from test where field=1"); is equivalent to $s = $db->prepare("select * from test where field=?"); $s->execute(array(

[GENERAL] Prepared queries

2004-02-11 Thread Cyril VELTER
I'm converting an application to use the V3 protocol features in the 7.4 libpq. As I need to make a design choice regarding the use of prepared statements, I'm wondering what ressources does a prepared statement use on the server ? If I need to create several hundred in each backend, is there a big