fastest postgresql module
Gerhard Haering
gh at ghaering.de
Thu Mar 17 19:12:11 EST 2005
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: Digital signature
URL: <http://mail.python.org/pipermail/python-list/attachments/20050318/b51302a8/attachment.sig>
More information about the Python-list
mailing list