Default OracleDataSet.ReadBuffer = 25

[AsusMan]

Hello!
By default, OracleDataSet.ReadBuffer = 25, why not?
Empirically determined ReadBuffer under which the use
Memory minimum: 19, 29, 44, 67, 100, 152, 225, 338, 508

Sorry for my english ...

 

[Marco Kalter]

What exactly is the question?

 

[AsusMan]

The default buffer size is not optimal in terms of
memory usage.
For example:
RecCount - 1000000
RecSize - 570

ReadBuffer Mem
25 132MB

 

[Marco Kalter]

I don't know what the exact cause for these numbers are, but a higher ReadBuffer value will result in more memory usage for the same query with the same result set.

 

[AsusMan]

I did a test on a different data set, the results were confirmed:
Readbuffer Memory
-----------------
19 622MB
25 804MB

 

[AsusMan]

 

[AsusMan]

I recommend the following values for the properties of the component Readbuffer OracleDataSet -
19 29 44 67 100 150 225 338 507 761 1141 2569 3853 5780