Fatal error: Maximum execution time of 30 seconds exceeded in C:\Inetpub\wwwroot\picture\edit.php on line 19
I execute in my database it have 15000 record. how should i do ? please answer to me.
thank you.
Add this to the code and see if it helps...
<?php set_time_limit(60); ?>
This would add 60 seconds to the excecution...
🙂
I assume you want to pull all records and the output is not being displayed to a user or similar - your testing or something? If not the case, don't increase the time limite but use LIMIT and create pages, maybe showing 50 records per page.
Thank you for your answer.
Yes, I retrieve all record to process it. I must process each of a block of record ?
Thank you
In that case, follow stephan's advice. Put it inside the loop so that it keeps resetting the timeout for as long as necessary to process everything.
You shouldnt really be displaying 1500 records all on the one page use Pagination so you can go through 'x' amount per page.
I wouldn't try and display 15,000 records on a single page, either; but I think they're supposed to be getting processed somehow.