[Gnumed-devel] re: posgres cursor protocol

[sjtan]

For each cursor(),  curs.execute('..') , curs.fetchall()     there's  4 
packets for cursor , and curs.execute  (   a cursor.declare, response, a 
query declare, response),
and 2 packets for fetchall( a cursor fetch,  a response packet with 
data) and a cursor close (2 packets). So 8 packets per query, if one 
query per cursor.
with say a 600 ms delay, it would take 8x 0.6 =  4.8 seconds to do one  
query.  On a test run it took 3 min 10sec for 897 packets, so that's 897 
/ 190 = 4.72 seconds
which is close.

Maybe we should begin work on the xml-rpc server, or whatever middleware 
is going to be used, just so showcasing  the public server will be a bonus.