For me it is still not clear how "StatementCache" works here and what it is used for.
Is it somehow related to TOracleDataset.cachedUpdates?
We have TOracleDataset.commitOnPost=true and TOracleDataset.CountAllRecords=true.
We see severe network performance degregation and now I would like to understand if "StatementCache" would do the trick that "StatementCacheSize" determines the number of records read in a chunk?
Or do we have to adjust all SQL-statements in the application to limit the amount of records to be read?