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 5.5.1
Copyright © 2012, Rogue Wave Software, Inc. All Rights Reserved.