We have a proc that is ran from cron nightly that gathers statistics about the number and types of messages being processed. This proc reads files that are saved as part of an inbound-tps for a number of threads.
The proc currently loops through the list of files and pulls the entire contents of the files into memory.
I am considering rewriting the proc so that it reads the data a line at a time.
I am hoping this eliminate the issues I am having.
Thanks,
Ryan