contrib: hack for psycopg2 performance

"P. Christeas" <[email protected]> Mon, 10 May 2010 20:45:53 +0300
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]>
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.

Code can be seen at 
http://git.hellug.gr/?p=xrg/psycopg2;a=shortlog;h=refs/heads/execparams

it is at a 'proof-of-concept' stage (only string, int and Null is working so 
far), where I feed the query with 1500 parameters and measure. In such an edge 
case, the performance improvement is remarkable. But you get the idea.

Your comments are welcome.


-- 
Say NO to spam and viruses. Stop using Microsoft Windows!