ASQL_BUFFER_SIZE

ASQL_BUFFER_SIZE can be set to any positive number, and causes AcuSQL to cache that many rows from a cursor when the cursor is read. This can result in much less traffic across the network, and, therefore, better performance. Values as small as 5 (to cache 5 rows) can result in a significant performance boost. Test your application for the optimal value to which to set this variable.

ASQL_BUFFER_SIZE is tested when a cursor is opened. Setting the variable programmatically after a cursor is open has no effect.