Improved Overall Range Performance

Previous Topic

Next Topic

Improved Overall Range Performance

Range performance was improved by using NXTKEY()/PRVKEY() instead of GTKEY()/LTKEY() when possible.

We discovered that range performance could be enhanced using NXTKEY() instead of GTKEY() to skip over records that did not meet range and/or filter criteria during range operations. Because NXTKEY() cannot always be substituted, the logic now determines when it must use GTKEY().