SET_FIXED_FILE_RECORDS_USED¶

This command is used to set DF_FILE_RECORDS_USED to a fixed value. This can be useful because doing a SELECT COUNT(*) is a very expensive process to the server. Many applications do counts often and using this command can help cut down the server traffic. Sometimes when counts are used, an exact number is not necessary so a fixed value, updated occasionally can be used. By setting this command to 0 or greater, the value of DF_FILE_RECORDS_USED will be set to that specified value and the internal SELECT COUNT(*) will be suppressed. If this command is set to something less that zero, DF_FILE_RECORDS_USED will be dynamically calculated whenever it is called.

The default value for this command is -1