I am using PHPExcel to export Excel from MySQL data. It works fine if it can be done within about 30 seconds. But once it is more than 30 seconds, it fails to export. The client web browser always displays a HTTP 500 error.
The Apache server by default is timeout with 300 seconds.
The MySQL interactive_timeout or wait_timeout is 28800 seconds.
The PHP timeout was changed to 120 seconds. In my PHP program, I also use set_time_limit() to add sufficiently longer time.
However, it still doesn't work. The 30 seconds timeout is still there. There is no problem with the data from MySQL.
In fact, the Excel file was partially generated as a .tmp on the server side.
I am running out of ideas what may go wrong. Does PHPExcel has a timeout of 30 seconds also?
Please help me. Thank you,