Out of memory

[Grisa]

Hi!

I use DOA 4.1.1.0 with Borland C++ ver. 5.0 and oracle db ver 11.2.0.3.0 - 64bit. When I try to get huge amount of data records (content of columns are not that tremendous) from server to the client I receive Out of Memory error. The query gives back 130.000 rows but after receiving ~115.000 rows it gives back the error.

How is it possible to get the data to client without any problem? I tried to set the ReadBuffer property of TOracleDataSet, but no changes. It's very urgent because it's a blocking issue in a production environment.

Br,
Mr Merges Miklos

 

[Marco Kalter]

By default a TOracleDataSet will buffer all fetched records, so processing 130.000 rows can lead to problems by default. To solve this you can set TOracleDataSet.UniDirectional to True. This way none of the records are buffered, but you cannot navigate backwards.