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. [EMAIL PROTECTED] ( ) -"-"----------------------------------------------------------------- http://alejandro.ceballos.info movil: (33) 3849-8936




--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to