1. 

   arpita, Member

   Hello

   I am facing a problem with excel download. i have a large data which loaded properly but when I click on the excel option the page thrown an error for timeout on lib\external\PHPExcel\PHPExcel\Worksheet.php on line 901
   then i add
   ini_set('max_execution_time','86400');

   Then the page throws memory allocation error
   so i add
   ini_set('memory_limit', '512M'); after the above line

   Then again it throws

   [Mon Aug 04 05:11:40 2014] [warn] [client 182.74.175.38] mod_fcgid: read data timeout in 31 seconds, referer: http://itsrhouse.ewaycorphosting.com/report.php?r=45&m=1&h=72464adc77920f265383acd741d88861fb7d4209&i=1

   [Mon Aug 04 05:11:40 2014] [error] [client 182.74.175.38] Premature end of script headers: report.php, referer: http://itsrhouse.ewaycorphosting.com/report.php?r=45&m=1&h=72464adc77920f265383acd741d88861fb7d4209&i=1

   Please suggest any solutions
2. 

   myDBR Team, Key Master

   The Excel export is memory and time consuming. If you have very large dataset, you might want to use CSV export.

   --
   myDBR Team

Reply

You must log in to post.