Re: Out of Memory

I was hoping this will help your review in providing a fix. I noticed the module fails trying to read the entire XML worksheet content at the biggest worksheet in my spreadsheet with 1 million rows in it -

<font size="6">
        foreach ($member_sheet -> contents =~ /(\<.*?\/?\>|.*?(?=\<))/
+g) {

</font>
[download]

Can we change this go line-by-line? or in chunks? not sure I totally understand how this works.

Comment on Re: Out of Memory Download Code

Replies are listed 'Best First'.
Re^2: Out of Memory by ETLTCHFIG (Novice) on May 06, 2011 at 00:14 UTC
I am in pretty bad shape gurus ... This is production being held up at our shop - and I am on the hook for this .. (going with PERL) ... could you please help me figure a way out here? I would truly appreciate it .. I feel like I have hit the roof here with my understanding .. cant figure how I would improve the following code that is trying to cache the whole unzipped worksheet in XML form into an array - `foreach ($member_sheet -> contents =~ /(\<.?\/?\>\|.?(?=\<))/ +g) {` [download] This the point where the program runs out of memory trying to read a 1 million record file Leon	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Out of Memory
by ETLTCHFIG (Novice) on May 06, 2011 at 00:14 UTC

I am in pretty bad shape gurus ... This is production being held up at our shop - and I am on the hook for this .. (going with PERL) ... could you please help me figure a way out here? I would truly appreciate it .. I feel like I have hit the roof here with my understanding .. cant figure how I would improve the following code that is trying to cache the whole unzipped worksheet in XML form into an array -

        foreach ($member_sheet -> contents =~ /(\<.*?\/?\>|.*?(?=\<))/
+g) {
[download]

[reply]
[d/l]