On Jan 24, 2005, at 1:38 PM, Christoffer Gurell wrote:
the thing is that i want to create a gui-widget that has the
possibility
to show a large amount of data over a slow connection. My idea was that
i create a cursor and create a srollbar with the number of rows in the
cursor so the user can scro
> yep. This is because one of the advantages of a cursor is that it only
> runs partially and returns the first X rows for the fetch. This keeps
> load down so that many cursors hitting the machine at once don't all
> materialize all their rows and chew up all that I/O, cpu, and memory.
> Unfort
On Mon, 2005-01-24 at 10:58, Christoffer Gurell wrote:
> > Not without actually scanning the result, if that's what you meant.
>
> so basically i have to do a move to the end ?
yep. This is because one of the advantages of a cursor is that it only
runs partially and returns the first X rows for
> Not without actually scanning the result, if that's what you meant.
so basically i have to do a move to the end ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
Christoffer Gurell <[EMAIL PROTECTED]> writes:
> When declaring a cursor is there a way to return the number of rows that
> the declared cursor consists of ?
Not without actually scanning the result, if that's what you meant.
regards, tom lane
---
When declaring a cursor is there a way to return the number of rows that
the declared cursor consists of ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTE
