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!