RE: PF with lotsa LFs

Do you have the luxury of having SQL on you system so you can build
dynamic sqls right in your RPG inquiry programs?

Otherwise there is the old opnqryf dynamic builds - as for overhead,
I have never gone that far, but, I do have a logical built over 5
rather large physical files - we get bit HARD if we do a re-org
on any of those files (by large I mean each file has well over
10 million records -  to some that would be average)

And these physicals each have 10 logicals over them - the
hits seem fine, but we took a lot of page fault hits until
we added memory and adjusted our pools.

HTH

Mark


-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
Behalf Of Tom Daly
Sent: Friday, February 08, 2002 10:32 AM
To: 'rpg400-l@midrange.com'
Subject: PF with lotsa LFs


Anyone ever have a file with 100+ logicals?

The design choice I'm facing is either fewer LFs but more complicated
inquiry programs & potential performance penalties vs. having many logicals
with simpler and quicker programs (less file reads).

Any wisdom on this?  Pitfalls?  Considerations?


Thanks...

Tom

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.