| J. Alejandro Ceballos Z. -JOAL- 2006-08-03, 6:55 pm |
|
I've created a perl routine that reads a RTF file, and while
interpreting, it is storing the information on a Mysql database.
It is like: while not EOF (read line, validate, db insert it)
The problem is that after a few registers (around 1'500,000) a message
of "out of memory" appears and the program stops.
I think that is because the programs runs faster than the information is
stored, so the queue of "insertions" grows and less memory for the process.
I tried using finish statement, but if it is after the insert, I got a
message "nothing to finish". If it is at the end... the programs first
become out of memory. I tried using a sleep command, but it is not working.
Any idea about how to prevent that "out of memory". Or maybe is another
kind of error?
--
,_,
(O,O) J. Alejandro Ceballos Z. buzon@alejandro.ceballos.info
( )
-"-"-----------------------------------------------------------------
http://alejandro.ceballos.info movil: (33) 3849-8936
|