The records are composed of two columns, a code (5 characters) and a description (average size 25 characters). The average size of the record is then approx. 30 characters. From the documentation available in Forms:
Also, the way in which the actual value is computed when a value of 0 isI believe that we are running with the default. Is this OK for this data set? Do we need to set the environmental variables listed above?
specified has changed. The actual value in this case is now
0.5 M / total_record_size (i.e. sum_of_column_sizes, not max_column_size),
but no more than 100 and no less than 20. The coefficients (0.5 M, 100, and
20) can be changed by setting these environment variables:
The Record Group Fetch Size Property Specifies The Size Of The Record Group To Be Fetched. A Larger Fetch Size Reduces The Number Of Fetches Required To Obtain The Record Group. For Example, A Record Group Of 5000 Records Will Require 500 Trips To Be Fetched If Record Group Fetch Size Is Set To 10 But 5 Trips If Record Group Fetch Size Is Set To 1000. So The Delay May Be Due To The Extra Fetches.
Hope This Helps.