7 messages in org.postgresql.pgsql-jdbcRe: how to monitor the amount of byte...
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:Re: how to monitor the amount of bytes fetched in a executeQuery()Actions...
From:Oliver Jowett (oli@opencloud.com)
Date:Jul 11, 2006 10:10:43 pm
List:org.postgresql.pgsql-jdbc

Albert Cardona wrote:

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?

Yes.

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?

I can't see any way to do this, unfortunately.

-O