Re: postgresql modules and performance

2005-04-24 Thread Mage
Reinhold Birkenfeld wrote: > >Have you tried psycopg? > > Thank you. It did the fetchall() in 11 secs and 13 secs with dictionary creating. It's the fastest so far. Mage -- http://mail.python.org/mailman/listinfo/python-list

Re: postgresql modules and performance

2005-04-24 Thread 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

postgresql modules and performance

2005-04-24 Thread Mage
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