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.
Published date: 05/24/2022
Last modified date: 02/24/2022