I am using PHPExcel for batch processing of data, exporting from a Postgres database into a spreadsheet and importing that spreadsheet back into postgres (presumably after it has been changed).
I am seeing substantial differences in the behavior of the application when running on Linux verses Windows.
The Linux platform is Centos 6.4 Windows 8.
In both cases the version of phpexcel is 1.7.8 and PHP is 5.4
My development case reads 1993 records from postgres (version 9.2 btw)
In the development, Windows always works and does so quickly.
On Linux, if I format the cells, the job never completes. If I do not format the cells, it does complete but runs slowly.
I've placed debugging code into the program and memory use does not get about 34 megs.
With formatting, the program stops after processing 1557 records and at that point has used 25 megs of memory.
$obj->getActiveSheet()->getStyle($col . $row)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
Does anyone have any theories on this behavior or where/how to proceed from here?