× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Generally speaking, has anyone tried or know for a fact which of the
following scenarios result in better performance (faster I/O?)?...
1.  READE on logical with a descending key  (ex:  READE (Company : Route :
Date) LOGICAL1 where Date is keyed descending)
2.  READPE on logical with an ascending key  (ex: READPE (Company : Route :
Date) LOGICAL2 where Date is keyed ascending).

I want to read records in a history transaction file keyed with a date
field starting with the most recent and going backward.  I'm trying to
decide whether I should build a new logical over a fairly large physical,
or use an existing logical and use READPE instead of READE.  I will be
likely reading potentially 10,000 to 50,000 records in one pass and
performance is an issue.

Let me know if you need more information, but I was hoping for a quick and
dirty response.

Thanks!

Ben Pforsich
Programmer Analyst
Bob Evans Farms, Inc.
I/S Department
Columbus, Ohio
Ben_Pforsich@xxxxxxxxxxxx


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.