Set maximum execution time in MYSQL / PHP
You can make it by setting set_time_limit in you php code (set to 0 for no limit)
set_time_limit(0);
Or modifying the value of max_execution_time directly in your php.ini
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 120
Or changing it with ini_set()
ini_set('max_execution_time', 120); //120 seconds
but note that for this 3rd option :
max_execution_time
You can not change this setting with ini_set() when running in safe mode. The only workaround is to turn off safe mode or by changing the time limit in the php.ini.
Source www.php.net
Harris Geo
Updated on August 01, 2022Comments
-
Harris Geo almost 2 years
I have an XML document that has around 48,000 children (~50MB). I run an INSERT MYSQL query that makes new entries for each one of these children. The problem is that it takes a lot of time due to its size. After it is executed I receive this
Fatal error: Maximum execution time of 60 seconds exceeded in /path/test.php on line 18
How do I set the Maximum execution time to be unlimited?
Thanks