A_SYB_ROWCOUNT configuration variable

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 row count has been determined. Use caution when setting this variable.

See also:A_SYB_ADD_IDENTITY