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.

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
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com