The SQL standard specifies a one-row fetch for cursors, which wastes network bandwidth. Using the set cursor rows query option and Open Client’s transparent buffering of fetches, you can improve performance:
ct_cursor(CT_CURSOR_ROWS)
Be careful when you choose the number of rows returned for frequently executed applications using cursors—tune them to the network.
See “Changing network packet sizes” on page 27 for an explanation of this process.
