7 messages in org.postgresql.pgsql-jdbchow to monitor the amount of bytes fe...
FromSent OnAttachments
Albert CardonaJul 11, 2006 11:27 am 
Nicholas E. WakefieldJul 11, 2006 8:17 pm 
Oliver JowettJul 11, 2006 10:10 pm 
Albert CardonaJul 12, 2006 8:55 am 
Oliver JowettJul 12, 2006 2:45 pm 
Albert CardonaJul 12, 2006 2:59 pm 
Oliver JowettJul 12, 2006 3:13 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:how to monitor the amount of bytes fetched in a executeQuery() ?Actions...
From:Albert Cardona (acar@ini.phys.ethz.ch)
Date:Jul 11, 2006 11:27:19 am
List:org.postgresql.pgsql-jdbc

Hi all,

I have a system in which large (13Mb) images are stored in the database as compressed bytea column entries. When fetching from the local computer it's fast enough the lag is not noticeable. When fetching remotely at 1Mb LAN speed, about 15 seconds elapse.

After timing the executeQuery() and the getBinaryStream(), the first takes about 15 seconds and the second about 3. So it looks like the executeQuery() is actually downloading the image, and the getBinaryStream is merely copying it from a local resource. Is that right?

Is there any way in which the number of bytes fetched in a query or for a particular column can be monitored, so I can display a more accurate and elaborated waiting dialog in my application?

Thanks for any hints.

Albert

-- Albert Cardona Molecular Cell Developmental Biology University of California Los Angeles Tel +1 310 2067376 Programming: http://www.ini.unizch.ch/~acardona/trakem2.html Research: http://www.mcdb.ucla.edu/Research/Hartenstein/ Web design: http://www.pixelets.com