search

iliaal / php_excel

PHP Extension interface to the Excel writing/reading library
http://ilia.ws
533 stars 131 forks source link

High Memory Usage #253

Closed lmstanky closed 4 years ago

lmstanky commented 4 years ago

Hi

The PHP extension for LibXL seems to use a lot of memory. I'm trying to write to between 1,000,000 and 8,000,000 cells, granted, but this is for an XLSX file that's only about 15MB maximum, and trying to produce it pushes the peak memory usage of the PHP FastCGI process to approximately 1GB.

Can you verify this is just how much memory the extension uses? Or is this just a PHP thing?

Thanks :)

johmue commented 4 years ago

you can read about a php_excel analysis (speed and memory here): https://blog.mayflower.de/4922-Performant-Handling-Excel-Files-PHP.html