You can specify the number of records to be included in the block of records copied from the cursor to the client buffer. The maximum cursor block size allowed by Dexterity is 255 records. You can specify the cursor block size in one of three ways:
|
The default cursor block size is 25. As the block size increases, a degradation of your application’s performance may occur. |
What block size is reasonable depends on the size of the data set. The greater the size of the data set and the smaller the cursor block, the greater the number of queries made against the database, and the greater the impact on performance. We recommend that you use the default block size of 25 for the best overall performance.