G
Guest
Hello, I have a fairly simple application which reads none to many input
files and edits them and if they are clean, it writes these transaction to
the database. Any errors it finds, it opens and error file and writes the
error message and the error transaction to this file. After the processing
of the file is complete, it will copy the original file to an archive
directory and then delete the original file.
The problem is that after processing about 25 files, it runs out of memory.
So I must be doing something wrong to cause the memory to continue to climb,
as it seems that it should reach a point where memory usage should level off
as it is doing the same thing over and over.
I am waiting until all the transactions from the file have been processed
until I do a commit (Oracle, not on the local box) which could be a couple of
thousand transactions, but I have been told that this should not have an
impact on my performance or memory use.
So how does one go about finding out why their memory usage continues to
climb?
Thanks in advance for your assistance!
files and edits them and if they are clean, it writes these transaction to
the database. Any errors it finds, it opens and error file and writes the
error message and the error transaction to this file. After the processing
of the file is complete, it will copy the original file to an archive
directory and then delete the original file.
The problem is that after processing about 25 files, it runs out of memory.
So I must be doing something wrong to cause the memory to continue to climb,
as it seems that it should reach a point where memory usage should level off
as it is doing the same thing over and over.
I am waiting until all the transactions from the file have been processed
until I do a commit (Oracle, not on the local box) which could be a couple of
thousand transactions, but I have been told that this should not have an
impact on my performance or memory use.
So how does one go about finding out why their memory usage continues to
climb?
Thanks in advance for your assistance!