Data Access User Manual > Data Access and SQL > SQL Tables > Run-Time Options > Cursor Buffering
 
Cursor Buffering
Cursor buffering is a way to obtain better throughput when fetching a large number of rows. It consists of having the lower layers of the database library fetch more than one row at a time from the database server.
By default, rows are obtained one at a time from the database server. This can seriously slow down the application when many rows have to be fetched since a network round-trip will be required for each row.
The setCursorBufferedRowsCount member function lets you specify how many rows can be fetched at one time.
IliSQLTable* sqlTbl;
...
sqlTbl->setCursorBufferedRowsCount(15);
Note that this will result in better throughput only with database servers that support this feature, which currently are Oracle and Sybase.

Version 6.2.1
Copyright © 2018, Rogue Wave Software, Inc. All Rights Reserved.