You could possibly modify the driver to start a thread in the background
to monitor the progress - hack. I just did some very similar to monitor
the amount of memory being used by a result set as it was being
generated.
-----Original Message-----
From: pgsq...@postgresql.org
[mailto:pgsq...@postgresql.org] On Behalf Of Oliver Jowett
Sent: Tuesday, July 11, 2006 10:11 PM
To: Albert Cardona
Cc: pgsq...@postgresql.org
Subject: Re: [JDBC] how to monitor the amount of bytes fetched in a
executeQuery()
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
7 messages in org.postgresql.pgsql-jdbcRe: how to monitor the amount of byte...
