Where does the data come from?
Is it all loaded up from a file at start-up? Or is it built-up over time as the process(es) run? Other?
====>From database, do some transform. Once done, never change.
Given the scant description of the data and processing, my only response is that rather than filling (more than) your memory capacity with data read from an RDBMS in order to do processing in Perl, you should be leaving the data in the DB and formulating SQL queries that allow the RDMBS to perform the processing for you.
Maybe if you explained why that is not possible, then an alternative solution might suggest itself, but it would require much more detail.
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
| [reply] |