Prefetch Num Recs (-prefetchNumRecs)

Use Prefetch Num Recs (-prefetchNumRecs) to increase the number of records placed in a network message before it is sent to a remote client.

Operating system and syntax UNIX / Windows -prefetchNumRecs n
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server 32766 >0 0 64
n
The number of prefetch records to put in a network message before sending the message to a waiting 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 the Manage the OpenEdge Database for a discussion of the interaction between the parameters.