Re: I cant find it or I'm just lazy ?

---------- Forwarded Message ----------

Subject: Re: [HACKERS] I cant find it or I'm just lazy ?
Date: Tue, 25 Feb 2003 17:51:13 +0000
From: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>

On Tuesday 25 February 2003 13:04, Christoph Haller wrote:
> > On Tuesday 25 February 2003 09:28, Christoph Haller wrote:
> > > > On Mon, Feb 24, 2003 at 07:53:05PM +0000, Darko Prenosil wrote:
> > > > > I need two answers I did not find in documentation :
> > > > > How can I get exact number of rows in DECLARED CURSOR ?
> > > > > OK, I can FETCH until NULL, but this does not fits my needs !
> > >
> > > You may want to use FETCH ALL, otherwise what or your needs in
>
> detail?
>
> > If I use FETCH ALL all, all the data will be sent to client, then why
>
> to use
>
> > CURSOR at all ? I need to reduce network traffic on slow connections !
>
> I cannot see how you are going to reduce network traffic by knowing in
> advance
> how many rows will be returned.
> Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
> function on the query to learn about the number of rows to be returned.

I am trying to create client buffer that will show only records that are
needed by application(visible). Data should be send to client in "pages", not
all the data at once. The idea is not to query for data that are already in
the buffer.

Regards !

-------------------------------------------------------