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” for an explanation of this process.
