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