OutOfMemory, when I use TOracleDataSet with query which have 20 field NVARCHAR2(2000) and 3000 rec

[Anatoliy]

OutOfMemory, when I use TOracleDataSet with query which have 20 field NVARCHAR2(2000) and 3000 records. BufferSize set on 100. What shall I do?

DOA 4.1.1
Oracle 10gR2 (Unicode CodePage) Patch 4
Delphi(2007,2009)

 

[Marco Kalter]

This dataset result set will hold 120MB. If possible, use a TOracleQuery or a TOracleDataSet in UniDirectional mode. In both cases there is no memory overhead for large result sets.

 

[Anatoliy]

if I set this property (UniDirection) or use TOracleQuery I won't use TDBGrid ((

 

[Marco Kalter]

Then perhaps you need to limit the result set to the records you are interested in by using QBE or a where clause. Viewing 3000 records in a DBGrid is not very useful. You can additionally set TOracleDataSet.QueryAllRecords to False, so that the dataset only fetches records when the application (grid) requests them.