fastest postgresql module

Gerhard Haering gh at ghaering.de
Fri Mar 18 01:12:11 CET 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.pgp>


More information about the Python-list mailing list