|
Tim, The performance penalty for file open/close is pretty severe, and it gets worse if you do journaling and/or commitment control. Generally, there's no need for user control (UC) unless you are issuing OVRDBF, OVRPRTF commands, separating splf reports, and so forth. I'd not use UC processing unless it's absolutely necessary. eric.delong@pmsi-services.com ______________________________ Reply Separator _________________________________ Subject: Re: DSPJOB open files display? Author: <MIDRANGE-L@midrange.com > at INET_WACO Date: 9/30/98 11:56 PM Hi and Thanks Pete, Yes this is what I am doing. I have a driving file that has several National Account #'s in it. I read one of the National Account #'s then I OPEN the second (UPDATE) file, SETLL on it with e partial key, then READE the records updating all the Equal records, then it drops out of the DOW loop and CLOSES the file. Then it reads the next National Accoun # and drops back into the above routine again. I thought the UC user area was the proper way to do the file updates? ~~~ (0 0) Tim & Dana Truax... and Caleb 5 years old. --ooO--(_)--Ooo-------------------------------------------- Pete Massiello wrote: > Are you opening and closing the file each time you go in and out of a > subroutine??? If you are, this is probably killing your performance. > > Pete > +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
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.