Re: contrib: hack for psycopg2 performance

Federico Di Gregorio <fog-NGVKUo/i/[email protected]> Tue, 11 May 2010 08:48:36 +0200
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
On 10/05/2010 19:45, P. Christeas 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.

I'll write a better reply later but let me just thank you for this. As
Daniele said it doesn't make much sense to replace the default
implementation of execute() in the short term but there is one place
where PQExecParams() is perfect: executemany(). Right now I am working
on the release but after 2.2.0 I'll have a look at your code and see how
we can integrate it into psycopg.

federico

-- 
Federico Di Gregorio                                       fog-NGVKUo/i/[email protected]
  Those who do not study Lisp are doomed to reimplement it. Poorly.
                                     -- from Karl M. Hegbloom .signature

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg
signature.asc (application/pgp-signature, 262 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkvo/coACgkQvcCgrgZGjesGnACgzioQ5znrT/5fC0o5KQI9nf8F
iX0AoLKDAeYPTJJXuqhWITHqQBvZ+TbQ
=CCob
-----END PGP SIGNATURE-----