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.