Prefetch Priority (-prefetchPriority)

-prefetchPriority n

n

The number of prefetch records to add to a network message.

Use Prefetch Priority (-prefetchPriority) to utilize a "pollskip" that adds n records to the network message of an in-process prefetch query without additional polling. Adding more than one record to the message at a time can greatly reduce the number of poll() calls being made on a large database configuration. The expected result is that reducing poll() calls improves overall system performance by decreasing the "System CPU" cycles allow for increased "User CPU" cycles. The pollskip only occurs if the previous poll() call returned nothing waiting.

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.