|
Ken Sims wrote: >You were doing fine until you hit the part quoted above. FRCRATIO(1) >forces the data not only to be written to the file but also the file pages >in memory to be written to the disk. This is a much bigger performance hit >than what is needed to make the records visible in the file. >To turn off record blocking, using OVRDBF with SEQONLY(*NO), or in RPG IV >you can also do it in the program with BLOCK(*NO) in the keywords part of >the F-spec. >This will cause the records to be written to the file immedidately, which >is a little performance hit, but not force the pages to be immediately >written to disk, so it is not nearly as much of a performance hit as >FRCRATIO(1). Thank you Ken. I'm working on a project right now where this will make a big difference. Seth Shields Julius Blum, Inc. Stanley, NC
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.