Having done processing of flat files in the way you have to, I can tell you that it's far, far easier, and often faster, to use a DB. Throughput is normally better, and having the data queryable in an easy way gives you the opportunity to analyze it in ways you may not have thought of, or though of but discarded because it was infeasable because of processing concerns. | [reply] |
OK, well I'd suggest you try running all of the processes in paralell -- to get an idea of how much 'spare time' you have. You know, process data in one process while some of the others are reading through the data files.
Then maybe try running just three at a time, and so forth.
--t. alex
Life is short: get busy!
| [reply] |