postgresql modules and performance

[Reinhold Birkenfeld]

Mage wrote:
>           Hello,
> 
> I started to write my PostgreSQL layer. I tried pyPgSQL and PyGreSQL. I
> made a *very minimal* performance test and comparsion with the same
> thing in php. Table "movie" has 129 record and many fields.
> 
> I found PyGreSQL / DB-API / fetchall horrible slow (32 sec in my test).
> PHP did 13 secs and it gave the result in associative array. Maybe I did
> something bad.

Have you tried psycopg?

Reinhold