http://www.perlmonks.org?node_id=1016053


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

Spreadsheet::ParseExcel::Stream uses Coro, that stuff could be buggy (or being used buggily)
  • Comment on Re^5: Reducing the memory usage of Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^6: Reducing the memory usage of Spreadsheet::ParseExcel
by Neighbour (Friar) on Jan 30, 2013 at 14:30 UTC
    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
    (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

      Well, it is an improvement over Spreadsheet::ParseExcel

      But it uses Spreadsheet::ParseExcel, but it also uses Coro