cibien has asked for the wisdom of the Perl Monks concerning the following question:
Hi Monks, sorry for my precedent wrong question....
Is possible delete parsed data (with spreadsheet::parseexcel) from ram memory?
Because my a script parses a series of Excel files, and write data I need with XML::LibXML in a xml file. The logic works fine but my problem is that I keep running out of ram memory (4gb). I'm processing the files sequentially and I'm losing a lot of memory with parsing each new file. Now I have over 30 big excel files and after parsed 5 excel file the ram memory is full and process very slow. I need delete the parsed data stored in ram memory just before start parsing the second excel file, and the same for each excel file. Or I need alternative cell handling techniques that store only one excel file at once to limit memory usage..Thankyou very much for your help
Andrea
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Delete parse data spreadsheet::parseexcel
by moritz (Cardinal) on Feb 05, 2013 at 18:58 UTC | |
by runrig (Abbot) on Feb 06, 2013 at 00:19 UTC | |
by moritz (Cardinal) on Feb 06, 2013 at 00:53 UTC | |
by runrig (Abbot) on Feb 06, 2013 at 16:00 UTC | |
by cibien (Novice) on Feb 05, 2013 at 19:58 UTC | |
by moritz (Cardinal) on Feb 05, 2013 at 20:14 UTC | |
by cibien (Novice) on Feb 05, 2013 at 20:21 UTC | |
by moritz (Cardinal) on Feb 06, 2013 at 00:05 UTC | |
by cibien (Novice) on Feb 06, 2013 at 22:44 UTC | |
by moritz (Cardinal) on Feb 07, 2013 at 06:56 UTC | |
| |
by cibien (Novice) on Feb 07, 2013 at 14:50 UTC | |
| |
Re: Delete parse data spreadsheet::parseexcel
by Kenosis (Priest) on Feb 05, 2013 at 18:51 UTC | |
by cibien (Novice) on Feb 05, 2013 at 20:03 UTC | |
by runrig (Abbot) on Feb 06, 2013 at 00:28 UTC | |
by cibien (Novice) on Feb 06, 2013 at 22:57 UTC |
Back to
Seekers of Perl Wisdom