|
Clearing Multiple Occurs Datastruces is a performance issue or not in case you have 9999 limit for arrays and all of them are filled. Program is not setting LR and all the variables / files are open for the next calls? What we do we only return the number of arrays we process next time. 1. We processed 10 records we send 10 records in resultset 2. we processed 9999 records we send 9999 records in resultset 3. we processed 3 records we send 3 records in resultset In the second request we filled 9999 arrays and they are still there in 3rd request but we send only 3 records. There is only one instance of this program but there could be 20-30 same type of programs sitting in memory and processing arrays and return resultsets. length of each array can be upto 500-1000 bytes Thanks
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.