Subject RE: [firebird-support] InterbaseExpress
Author Alan McDonald
> Hi
> 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)
anyway - my concern would be the server RAM. the server needs to buffer up
those records and hand them over to the client.
either way it's something to be avoided - best practice... keep your
resultsets short and snappy