A_SYB_ROWCOUNT

This variable has an effect only if you are reading on a key that does not allow duplicates, or if you have added an Identity column to the table. A_SYB_ROWCOUNT determines how many rows are returned by a SELECT statement sent to the server.

This variable can be used to speed up the Acu4GL product. For example, if you know you will be reading only one record at a time, and reading from a unique key, you can set A_SYB_ROWCOUNT to "1", thus speeding up the processing.

If you know you are going to be reading records ten rows at a time, set A_SYB_ROWCOUNT to "10". If you don't have any information about how many rows are going to be requested, set this variable to "0", which is the default.

Note: Setting this variable to a non-optional value can actually degrade performance, since the interface may be forced to issue more SELECT statements once the rowcount has been determined. Use caution when setting this variable.

See also

A_SYB_ADD_IDENTITY runtime configuration file variable