From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Albert Cardona <acardona(at)ini(dot)phys(dot)ethz(dot)ch> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: how to monitor the amount of bytes fetched in a executeQuery() |
Date: | 2006-07-12 05:11:06 |
Message-ID: | 44B4846A.3010307@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Herbert | 2006-07-12 10:22:51 | Re: Limit vs setMaxRows issue |
Previous Message | Oliver Jowett | 2006-07-12 05:08:36 | Re: executeQuery Locked |