fastest postgresql module

[Timothy Smith]

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.

[Leif B. Kristensen]

Re: fastest postgresql module

Timothy Smith skrev:
[color=blue]
> 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.[/color]

You might want to try psycopg, it's claimed to be optimized for speed.
--
Leif Biberg Kristensen
just another global village idiot

[Timothy Smith]

Re: fastest postgresql module

Leif B. Kristensen wrote:
[color=blue]
>Timothy Smith skrev:
>
>
>[color=green]
>>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.
>>
>>[/color]
>
>You might want to try psycopg, it's claimed to be optimized for speed.
>
>[/color]
my only issue with psycopg, is last time i looked they had no win32 port?

[Leif B. Kristensen]

Re: fastest postgresql module

Timothy Smith skrev:
[color=blue]
> my only issue with psycopg, is last time i looked they had no win32
> port?[/color]

Uh, in that case, maybe you should consider changing platform? 8^)
--
Leif Biberg Kristensen
just another global village idiot

[Timothy Smith]

Re: fastest postgresql module

Leif B. Kristensen wrote:
[color=blue]
>Timothy Smith skrev:
>
>
>[color=green]
>>my only issue with psycopg, is last time i looked they had no win32
>>port?
>>
>>[/color]
>
>Uh, in that case, maybe you should consider changing platform? 8^)
>
>[/color]
my app has to be multiplatform, but i would gladly rip windows from the
drives of every computer with my bare hands.

[Gerhard Haering]

Re: fastest postgresql module

On Fri, Mar 18, 2005 at 09:31:45AM +1000, Timothy Smith wrote:[color=blue]
> Leif B. Kristensen wrote:
> [color=green]
> >Timothy Smith skrev:[color=darkred]
> >>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.
> >>
> >>[/color]
> >
> >You might want to try psycopg, it's claimed to be optimized for speed.
> >
> >[/color]
> my only issue with psycopg, is last time i looked they had no win32 port?[/color]

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFCOhzbdIO 4ozGCH14RAvyLAJ 9oL1hN4zgQ4D/3FHenvJWqsbCJ7g CgwiVx
8hxp/lCygeqFJ1Jiwm2I W7Y=
=Xtq3
-----END PGP SIGNATURE-----

[casevh@comcast.net]

Re: fastest postgresql module

With the round-trip time of 245ms, three seconds only allows for
approximately 12 packet exchanges (roughly 24 total packets). I think
latency is your problem.

casevh

[Josef Meile]

Re: fastest postgresql module

> my only issue with psycopg, is last time i looked they had no win32 port?
Not completely true. Since long time ago there is a website with
unofficial psycopg binaries:

http://www.stickpeople.com/projects/python/psycopg/

Regards,
Josef

[Frank Miles]

Re: fastest postgresql module

In article <mailman.545.11 11102310.1799.p ython-list@python.org >,
Timothy Smith <timothy@open-networks.net> wrote:[color=blue]
>Leif B. Kristensen wrote:
>[color=green]
>>Timothy Smith skrev:
>>
>>
>>[color=darkred]
>>>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.
>>>
>>>[/color]
>>
>>You might want to try psycopg, it's claimed to be optimized for speed.
>>
>>[/color]
>my only issue with psycopg, is last time i looked they had no win32 port?[/color]

psycopg is available for win32 (though the development version might not be)
Try:

http://www.stickpeople.com/projects/python/psycopg/

HTH...
-frank
--

[Gerhard Häring]

Re: fastest postgresql module

Timothy Smith wrote:[color=blue]
> [...] is there anyway i can check
> is it true psycopg is much faster or is it all hyperboll[/color]

The overhead of psycopg per cursor row is a lot less. So it makes a
difference if you fetch *a lot* of data.

Anyway, if you don't have a performance problem, you don't need to care ;-)

Yes there is a way to try it out, install it and compare :-P

As I said, there is a win32 version of psycopg if that's the only
platform you have access to:

Google - first hit:

http://www.google.de/search?hl=de&q=psycopg+win32&btnG=Google-Suche&meta=

=>

http://www.stickpeople.com/projects/python/psycopg/

-- Gerhard