<?xml version="1.0" encoding="windows-1252"?>
<node id="1016064" title="Re^6: Reducing the memory usage of Spreadsheet::ParseExcel" created="2013-01-30 09:30:56" updated="2013-01-30 09:30:56">
<type id="11">
note</type>
<author id="806480">
Neighbour</author>
<data>
<field name="doctext">
Well, it is an improvement over Spreadsheet::ParseExcel.
&lt;c&gt;
Before creating new Spreadsheet::ParseExcel and parsing file:
             total       used       free     shared    buffers     cached
Mem:          3011        345       2666          0          4        185
-/+ buffers/cache:        154       2857
Swap:          956        182        774
Killed
&lt;/c&gt;

(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).&lt;br&gt;
From dmesg:
&lt;c&gt;
[10998050.203177] Out of memory: Kill process 32189 (testinterfaces.) score 676 or sacrifice child
[10998050.203180] Killed process 32189 (testinterfaces.) total-vm:2893916kB, anon-rss:1958024kB, file-rss:0kB
&lt;/c&gt;</field>
<field name="root_node">
1014438</field>
<field name="parent_node">
1016053</field>
</data>
</node>
