I have a problem I like to generate a very large excel 2007-file which has round about 10M cells. I know that every row needs about 1k / each cell.
I started with generating a excel workbook with 100k cells and everything worked fine.
After I increased the number of cells I got some errors (memory_limit and max_execution_time). So increased the limits ...
Since 2M cells I only get an error "500 - Internal server error.", no memory or time error like expected. I found no entry for that in php errorlog or in windows log. What can I do now?
Operating System: Windows 2008 Server SP 2
Webserver: IIS 7.0
RAM: 32 GB
CPU: 8 CPU
I use the cell caching method cache_in_memory_serialized. I read in other discussion to use use other methods, but nothing changed except the performance of the writing process ...
Writing 1M worked fine, it took 81 seconds to generate the excel-file with a size of 3,26 MB.
My last limits:
Has anybody an idea what I can do now?
Thanks for your help!