Reading large table
Posted: Tue 25 Aug 2009 14:13
Hi.
I am reading a large table and writing it to a SDAC table, and I have discovered that the entire table is being read into memory although I have made it unidirectional and set fetchrows to 100.
The result is, that the table consumes more an more memory as the proces runs.
Is there a way to read the table in chunks of about 100 records, dropping them out of memory as the next 100 records are read ?
TIA Jens Lund
I am reading a large table and writing it to a SDAC table, and I have discovered that the entire table is being read into memory although I have made it unidirectional and set fetchrows to 100.
The result is, that the table consumes more an more memory as the proces runs.
Is there a way to read the table in chunks of about 100 records, dropping them out of memory as the next 100 records are read ?
TIA Jens Lund