Re: contrib: hack for psycopg2 performance

"Ross J. Reedstrom" <reedstrm-OhmvVRJSr/[email protected]> Wed, 12 May 2010 13:20:16 -0500
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
On Wed, May 12, 2010 at 01:04:55PM -0400, Michael Tharp wrote:
> On 05/10/2010 05:54 PM, Daniele Varrazzo wrote:
> >PQexecParams has the shortcoming of being able to send only a query at
> >time, whereas PQexec allows to send any number in a single string,
> >separated by semicolons. Many people use this feature and dropping it
> >would be an incompatible change. How would you work around that?
> 
> Can you "pipeline" statements in libpq? e.g. send three statements as 
> separate commands but without waiting for the replies to the first two.

Not w/ PQexec or PQexecParams, but from the functions below those:

http://www.postgresql.org/docs/8.4/static/libpq-async.html

Ross
-- 
Ross Reedstrom, Ph.D.                                 reedstrm-OhmvVRJSr/[email protected]
Systems Engineer & Admin, Research Scientist        phone: 713-348-6166
The Connexions Project      http://cnx.org            fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E  F888 D3AE 810E 88F0 BEDE