1. 

   Tom, Member

   Hi,

   One of my users is running a large report and export it to excel. However, PHP errors out with "time limit exceeded".

   The user is prepared to wait a longer time, so what would be the best option for me?

   - can mydbr use set_time_limit(0); in its code?
   - change the php settings?

   It would be a bit of a nuisance to change the entire report structure to use a sort of datawarehouse approach, so if possible I'd like to consider one of the above solutions first.

   Best regards
2. 

   myDBR Team, Key Master

   PHP in default installation has default timeout of 30 seconds. You can change it in php.ini max_execution_time setting.

   Excel export with large data sets require time and memory. If you do not need the formatting, a CSV export is an alternative.

   --
   myDBR Team

Reply

You must log in to post.