On Fri, Mar 18, 2005 at 09:31:45AM +1000, Timothy Smith wrote: > Leif B. Kristensen wrote: > > >Timothy Smith skrev: > >>has anyone got some hard numbers on which pg access module is the > >>fastest, i currently use pypgsql, but i can't help but feel it's a > >>little slow. > >>3 seconds to connect, send one query, get th return data. > >>i'm on a adsl 1.5mbit/256kbit link, the server is on a 10/10mbit, and > >>i have a ping of 245ms average. > >>maybe pypgsql does too much backand forth, i don't know. > >> > >> > > > >You might want to try psycopg, it's claimed to be optimized for speed. > > > > > my only issue with psycopg, is last time i looked they had no win32 port?
It has one now. But (of course depending on your query), your issue is not dependant on the particular PostgreSQL, I think. You'll probably also have it with executing a plain vanilla script via psql. -- Gerhard
signature.asc
Description: Digital signature
-- http://mail.python.org/mailman/listinfo/python-list
