[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] re: posgres cursor protocol

From: sjtan
Subject: [Gnumed-devel] re: posgres cursor protocol
Date: Mon, 07 Jun 2004 12:02:14 +1000
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113

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.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]