Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Prefetch Num Recs (-prefetchNumRecs)
 
Prefetch Num Recs (-prefetchNumRecs)
Operating system and syntax
UNIX Windows
-prefetchNumRecs n
Use with
Maximum value
Minimum value
Single-user default
Multi-user default1
DBS
32766
1
16

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.
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 Prefetchfactor (-prefetchFactor) parameter. See Prefetch tuning for a discussion of the interaction between the parameters.