Re^6: Reducing the memory usage of Spreadsheet::ParseExcel

in reply to Re^5: Reducing the memory usage of Spreadsheet::ParseExcel
in thread Reducing the memory usage of Spreadsheet::ParseExcel

Well, it is an improvement over Spreadsheet::ParseExcel.

Before creating new Spreadsheet::ParseExcel and parsing file:
             total       used       free     shared    buffers     cac
+hed
Mem:          3011        345       2666          0          4        
+185
-/+ buffers/cache:        154       2857
Swap:          956        182        774
Killed
[download]

(For those not familiar with *nix, when a machine runs out of memory, the kernel starts killing processes to free some. Usually, the first process to go is the one that claimed the most, like in this case my testprogram that tries to parse the xls-file).
From dmesg:

[10998050.203177] Out of memory: Kill process 32189 (testinterfaces.) 
+score 676 or sacrifice child
[10998050.203180] Killed process 32189 (testinterfaces.) total-vm:2893
+916kB, anon-rss:1958024kB, file-rss:0kB
[download]

In Section Seekers of Perl Wisdom