From: zentara <[EMAIL PROTECTED]> > On Mon, 10 Jan 2005 12:53:50 +0200, [EMAIL PROTECTED] (Octavian Rasnita) > wrote: > > >Hi, > > > >I have made a perl module object oriented which is something like > >this: > > > >use Spreadsheet::ParseExcel; > >use DBI; > > >Then I access the parse() method in another program that feeds the > >module with more Excel files (around 500 files). > > > >After more files parsed (around 300), the memory is full. > > > >Please tell me what can I do to free the memory after each file > >parsed by the module. > > > >I run this program manually or by a cron job, but I would like to > >know better how to free the memory because I might want to use it > >under mod_perl. > > > >Thank you very much for any tip. > > Maybe you can get something out of > > http://perlmonks.org/index.pl?replies=1;displaytype=print;node_id=3797 > 43 > > Reducing the memory usage of Spreadsheet::ParseExcel
Good to know, but this'd require rather big changes in the script. Besides it doesn't seem the problem is in parsing a single file. It seems there is a memory leak either in the script or in the module that causes the memory not to be freed when done with a file. Octavian, could you try to create a minimal example that displays this behaviour? Or, if not too long, show us the actual code? Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
