Prefetch Num Recs (-prefetchNumRecs)
- Last Updated: October 13, 2025
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.