> Alan,
>
> > > Just to be sure.
> > > Using an InterbaseExpress comp. (TIBQuery).
> > >
> > > Selecting for instance 1.000.000 record (like select * from table) an
> > > running through them using first ... next ...
> > > will use some memory.
> > >
> > > But when making it unidirectional it will use significantly less
> > > memory, right ?
> > >
> > > Michael
> >
> > memory on the client is not such an issue - depends on the size of each
> row.
> > a million ID integers is not the same as a million rows of 350
> varchar(128)
> > fields.....
> > anyway - my concern would be the server RAM. the server needs
> to buffer up
> > those records and hand them over to the client.
>
> But the server will flush them to disk if needed.

which is exactly where they just came from. what a waste of server energy to
pick them up form point A and put them back in position B

>
> And given that Firebird has no bi-directional cursors, this does seem
> a client problem.
>
> > either way it's something to be avoided - best practice... keep your
> > resultsets short and snappy
>
> Agreed.
>
> With regards,
>
> Martijn Tonies