psycopg

	Hello,

	How's it going ?

	I noticed a speed difference between the various postgresql interfaces :

	For the same query, returning 40000 rows of data (one column integer, one  
column integer[]), I have the following timings :

	pyPgSQL :	10.20 s
	pgdb :	4.36 s
	psycopg :	0.38 s

	pyPgSQL is slow because it converts the integer[] to a class og its own  
(PgIntArray or something).
	pgdb is just slow
	psycopg is written entirely in C.

	Using a conversion function of my own, I select, retrieve and convert  
(integer[] -> python list) the 40.000 rows in about one second.

	So, I guess SkunkWeb needs a psycopg interface ;)



-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click