On Wed, Apr 22, 2009 at 9:48 PM, Stephen Frost <sfrost@xxxxxxxxxxx> wrote: > Erm.. Prepared queries is about using PQexecPrepared(), not about > sending a text string as an SQL EXECUTE(). PQexecPrepared takes an > array of arguments. That gets translated into a Bind command in the > protocol with a defined number of parameters and a length for each > parameter being passed. That removes any need for scanning/parsing the > string sent to the backend. That's the savings I'm referring to. I'd suggest this be mentioned in the sql-prepare documentation, then, because that documentation only discusses using prepared statements to eliminate redundant planning costs. (I'm sure it's mentioned in the API docs and elsewhere, but if it's a major intended use of PREPARE, the PREPARE documentation should make note of it.) -- Glenn Maynard -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
