Re: contrib: hack for psycopg2 performance

Daniele Varrazzo <[email protected]> Mon, 10 May 2010 22:54:46 +0100
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
On Mon, May 10, 2010 at 6:45 PM, P. Christeas <[email protected]> wrote:
> Great news everybody!
> in my first post to this list, I'd like to announce that I've been
> experimenting with the code, in order to boost the performance.
>
> One main idea is to effectively replace PQExec() with PQExecParams() and then
> avoid most of this quoting, casting  etc.

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?

-- Daniele