Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Network Communication : Prefetch tuning : Specifying number of records prefetched
 
Specifying number of records prefetched
The -prefetchNumRecs parameter specifies a number of records to attempt to put into a network message prior to sending the message across the network. A higher value can create a longer delay in sending the message. This delay can improve overall system performance by reducing network traffic, but individual clients may encounter choppy responses from the server. The range of allowable values for- prefetchNumRecs is between 1 and 32,766. The default is 16, which is identical to the behavior before this value was tunable.