Re: Reducing the memory usage of Spreadsheet::ParseExcel

Would it be possible to convert the data structures used to ones that are less memory-consuming? For example, I know you use hashrefs. What about using arrayrefs and constants for the indices? That should reduce memory usage by about 15%. Also, you could move to an inside-out objects type of structure, which would help even more here because you have lots of little structures.

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

I shouldn't have to say this, but any code, unless otherwise stated, is untested

Comment on Re: Reducing the memory usage of Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^2: Reducing the memory usage of Spreadsheet::ParseExcel by jmcnamara (Monsignor) on Aug 09, 2004 at 13:17 UTC
Valid points but just to clarify, Takanori Kawai wrote and maintains Spreadsheet::ParseExcel. I am the positron to his electron. `:-)` -- John.	[reply]
Re^3: Reducing the memory usage of Spreadsheet::ParseExcel by dragonchild (Archbishop) on Aug 09, 2004 at 16:38 UTC
blushes I saw one module and responded about another. :-) ------ We are the carpenters and bricklayers of the Information Age. Then there are Damian modules.... sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon.* - flyingmoose I shouldn't have to say this, but any code, unless otherwise stated, is untested	[reply]