I am using PHPExcel to generate a report.
Problem is that it takes very long time, approx 30 secs for a limited subset of 1000 rows entries.
Profiling on 1000 rows, shows the majority of the execution time is lost on the save operation, split mostly between the PHPExcel_Writer_Excel2007_Worksheet->_writeCols and PHPExcel_Writer_Excel2007_Worksheet->_writeSheetData (picture attached).
The end of the code used to generate the report:
$objPHPExcel = new PHPExcel();
..... lot of irrelevant lines...
$ExcelWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
Profiling for 1000 rows:
Any ideas for ways to optimize the saving? to make it more scalable for much bigger reports?