-prefetchNumRecs n

n

The number of prefetch records to put in a network message before sending the message to a waiting remote client.

Use Prefetch Num Recs (-prefetchNumRecs) to increase the number of records placed in a network message before it is sent to a remote client. Setting Prefetch Num Recs (-prefetchNumRecs) may cause a waiting remote client to wait longer for full network messages containing prefetched records, but overall system performance is expected to improve by saving on network traffic. Another possible side-effect is that an individual remote client see might see "choppy" responses from the server.

The number of records in a network buffer is also influenced by the Prefetch factor (-prefetchFactor) parameter. See Prefetch tuning for a discussion of the interaction between the parameters.

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.