A-MSSQL-ROWCOUNT

This variable only has an effect if you are reading on a key that does not allow duplicates, or if you have added an Identity column to the table. A-MSSQL-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-MSSQL-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-MSSQL-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-MSSQL-ADD-IDENTITY runtime configuration file variable.