PEAR Spreadsheet Excel Writer memory exhausted
Posted: Thu Apr 07, 2011 3:28 am
Hello
Got a strange problem when trying to create a quite heavy excel file (1.8M). It only works if I set php_value memory_limit 1250M.
The created excel file is constantly growing in size due to new data inserted in DB. So I have to increase memory_limit all the time, which is not very cool, as u understand:)
If I don't increase this value the script will give me fatal error:
Allowed memory size of 587202560 bytes exhausted (tried to allocate 205455 bytes) in /usr/share/php/Spreadsheet/Excel/Writer/BIFFwriter.php on line 158
So I am looking for any method to reduce this unbelievable memory usage.
Any help will be much appreciated:)
Got a strange problem when trying to create a quite heavy excel file (1.8M). It only works if I set php_value memory_limit 1250M.
The created excel file is constantly growing in size due to new data inserted in DB. So I have to increase memory_limit all the time, which is not very cool, as u understand:)
If I don't increase this value the script will give me fatal error:
Allowed memory size of 587202560 bytes exhausted (tried to allocate 205455 bytes) in /usr/share/php/Spreadsheet/Excel/Writer/BIFFwriter.php on line 158
So I am looking for any method to reduce this unbelievable memory usage.
Any help will be much appreciated:)