According to the November 1998, Volume 1, Number 1, issue of AS/400 Experts
Journal; in an article by Skip Marchesani:

Access Paths are a Good Thing
There is a myth in the AS/400 community that is no longer true.  That is:
Access paths (logical files) on a file are resource intensive, have a
negative impact on performance, and should only be used where absolutely
necessary.

This is no longer true in today's environment on the AS/400!
The myth stems from the S/38 and was the guideline that IBM was giving
customers at that time.  The Rochester development lab began to change the
algorithms for access path maintenance in Version 2 of OS/400 and finished
the task in V3R1.  Access paths (logical files) are no longer the
resource/performance hog they used to be on the S/38.


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    Barb Nash
                    <Barb.Nash@phbcorp.       To:     midrange-l@midrange.com
                    com>                      cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     Multi format logical 
file - will it be a resource hog?
                    drange.com


                    01/28/2002 04:37 PM
                    Please respond to
                    midrange-l






Hi there,
           I have been given the specs to create the files for a new
tooling
system.  So far I have 26 different file formats.  I was thinking of
creating a physical file for each format and then a multiformat logical
file.  Will this multiformat logical file be a resource hog when used in
various RPG and COBOL programs?  Query?  Is there a better solution??

TIA,
Barb Nash
PHB, Inc.
Fairview, PA

Phone: (814) 474-1552 extension 225

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.