I'm having problems generating Excel spreadsheets using PHPExcel when the number of records is too large, the memory is insufficient to process the job, is there any way to improve the creation of this file through some caching system?
I'm having problems generating Excel spreadsheets using PHPExcel when the number of records is too large, the memory is insufficient to process the job, is there any way to improve the creation of this file through some caching system?
I suggest you increase memory in php.ini
. My is php7.0
in Ubuntu 14
, stays /etc/php/7.0/apache2/php.ini
On line 389 I put it like this:
Memory_limit = 768M
To edit php.ini
I suggest that you use vi
in Ubuntu.
It is possible to increase memory in the php.ini file, for example located on my machine at:
/usr/lib/php/7.0/php.ini-development
Or directly in the php code
ini_set('memory_limit', '4096M');