Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Increasing performance when sequentially reading an indexed file

Increasing performance when sequentially reading an indexed file

Problem

A customer has noticed that on a rather large indexed file, the performance seems to suffer when reading sequential through the entire file.

Is there a way to increase the performance of indexed file I-O when doing sequential reads?

Resolution:

They might look into using the extfh.cfg option called NODESIZE.
This controls the size of the index nodes that are used for a file when it is created.

The larger the value, the more keys that can be stored into a single node and this can speed up sequential processing quite a bit.

In a recent test when reading sequentially through an indexed file containing 8 million records, the following timings were achieved by setting the NODESIZE and recreating the file:

NODESIZE     Timing
1024                3 mins 55 secs
4096                3 mins 03 secs
16384              1 mins 59 secs

 

 

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-04-19 08:48
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.