Re: how to monitor the amount of bytes fetched in a executeQuery()

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

In response to

Responses

Browse pgsql-jdbc by date

  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