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.
Molecular Cell Developmental Biology
University of California Los Angeles
Tel +1 310 2067376
Web design: http://www.pixelets.com
pgsql-jdbc by date
|Next:||From: Chris White (cjwhite)||Date: 2006-07-11 18:55:18|
|Previous:||From: Mark Lewis||Date: 2006-07-11 18:27:11|
|Subject: Re: executeQuery Locked|