PHP Excel slow performance

Topics: Developer Forum, Project Management Forum, User Forum
May 21, 2014 at 8:46 PM
Hello everyone i have two problems first


I have 50.000 rows to write in an excel each one with 11 columns and it takes sooo long (more than 3 minutes).

Is there any chance to write it faster??

then i have a problem with fatal error memory allocated,... i increased the memoriy_limit of php to 512M but my array tries to allocat 32M and does not work :(

any clue?
Coordinator
May 21, 2014 at 10:09 PM
Perhaps is you showed your code for writing the workbook, it'd be easier to help with suggestions; or if you searched the board here for any suggestions that have been made previously.

As regards memory, what cell caching method are you using? Some are more memory efficient than others