When updating the database using the PHP program, it will always be interrupted when it reaches 160000. check the LOG and display the error that exceeds the maximum PHP execution time. you only need to add the following statement to the PHP script to solve the problem:
Set_time_limit (900 );
This function specifies the maximum execution time of the current php script,
Although the value is set to 900 seconds
Maximum execution time = max_execution_time value in php. ini-time when the current script has been executed + set value
If max_execution_time = 30 in php. ini and the current script has been executed for 10 seconds, then:
The maximum execution time is 30-10 + 900 = 920 seconds.
After this modification, the PHP script successfully updates 200000 records.
The above is passed in the LAPP environment.
In addition, it is said that this method is invalid in windows. in windows, you must specify the max_execution_time value in php. ini.
Not tested.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.