StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHPExcel Timeout occur
text
Body
copied!<p>Please help me for the the problem exporting large data to excel format xlsx. i m exporting almost 45000 records at a time to single file and it timeout without saving file. the mysql select query is taking 21 seconds for executing that large data. Below is my code to export data in to Excel file using PHP Excel library. </p> <pre><code> $sql2 = "SELECT * FROM Surveys"; $result2 = mysql_query($sql2); while($row2 = mysql_fetch_assoc($result2)) { $j=$rowscounter+2; $sheet->setCellValue("A$j",$row2['brandname']); $sheet->setCellValue("B$j",$row2['productname']); $sheet->setCellValue("C$j",$row2['sname']); $sheet->setCellValue("D$j",$row2['smobile']); $sheet->setCellValue("E$j",$row2['semail']); $sheet->setCellValue("F$j",$row2['country']); $sheet->setCellValue("G$j",$row2['city']); $sheet->setCellValue("H$j",$row2['sdob']); $sheet->setCellValue("I$j",$row2['age']); $sheet->setCellValue("J$j",$row2['comment']); $sheet->setCellValue("K$j",$row2['outletcode']); $sheet->setCellValue("L$j",$row2['username']); $sheet->setCellValue("M$j",$row2['datetime']); $sheet->setCellValue("N$j",$row2['duration']); $rowscounter++; } // Rename worksheet $sheet->setTitle('Survey-Report'); $objPHPExcel->setActiveSheetIndex(0); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->setPreCalculateFormulas(false); unlink("Survey-Report.xlsx"); $objWriter->save('Survey-Report.xlsx'); echo "ok"; </code></pre> <p><B>UPDATE:</B></p> <p>I forgot to mention that I already tried set_timout etc and wrote below code in my php file.</p> <pre><code>set_time_limit(0); ini_set('memory_limit','2500M'); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload