Re: fastest postgresql module

2005-03-19 Thread Gerhard Häring
Timothy Smith wrote: [...] is there anyway i can check is it true psycopg is much faster or is it all hyperboll 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 ;-)

Re: fastest postgresql module

2005-03-18 Thread Frank Miles
In article <[EMAIL PROTECTED]>, Timothy Smith <[EMAIL PROTECTED]> 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 se

Re: fastest postgresql module

2005-03-18 Thread Josef Meile
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 -- http://mail.python.org/mailman/listinfo/python-list

Re: fastest postgresql module

2005-03-17 Thread casevh
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 -- http://mail.python.org/mailman/listinfo/python-list

Re: fastest postgresql module

2005-03-17 Thread Gerhard Haering
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 connec

Re: fastest postgresql module

2005-03-17 Thread Timothy Smith
Leif B. Kristensen wrote: Timothy Smith skrev: my only issue with psycopg, is last time i looked they had no win32 port? Uh, in that case, maybe you should consider changing platform? 8^) my app has to be multiplatform, but i would gladly rip windows from the drives of every computer wi

Re: fastest postgresql module

2005-03-17 Thread Leif B. Kristensen
Timothy Smith skrev: > my only issue with psycopg, is last time i looked they had no win32 > port? Uh, in that case, maybe you should consider changing platform? 8^) -- Leif Biberg Kristensen just another global village idiot -- http://mail.python.org/mailman/listinfo/python-list

Re: fastest postgresql module

2005-03-17 Thread Timothy Smith
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 serve

Re: fastest postgresql module

2005-03-17 Thread Leif B. Kristensen
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/10mbi