Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : Prefetch Num Recs (-prefetchNumRecs)
 

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
1
—
161
1 Prior to Release 11.1, 16 was the static setting.

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 Prefetchfactor (-prefetchFactor) parameter. See the OpenEdge Data Management: Database Administration for a discussion of the interaction between the parameters.