致命错误:超过了400秒的最大执行时间 [英] Fatal error: Maximum execution time of 400 seconds exceeded
问题描述
我有一个PHP脚本,当执行较长的mysq_query时失败.错误消息是:
I have a PHP script that fails when executing a long mysq_query. The error message is:
致命错误:在...中超过了400秒的最大执行时间.
Fatal error: Maximum execution time of 400 seconds exceeded in....
我在Windows上使用XAMPP,并且更改了php.ini文件(我的安装中只有一个),将max_execution_time设置为一个大的值,而不是400秒.尽管如此,我仍然收到上面的错误消息....
I use XAMPP for windows and I have changed the php.ini file (there is only one in my installation), setting max_execution_time to a large value that is not 400 seconds. Nevertheless I keep getting the error message above....
关于如何解决这个问题的任何想法?
Any idea of how to solve this?
谢谢
Beto
推荐答案
正如Ignacio所说,某些内容可能会覆盖php.ini设置.您可以使用set_time_limit
As Ignacio says, something may be overriding the php.ini setting. You can definitively set the timeout for that script using set_time_limit
set_time_limit(600);
您也可以将其设置为0,这消除了任何时间限制-尽管这不是最佳做法.
You can also set it to 0, which removes any time restriction - although this is not best practice.
400秒的查询时间很长-您是否考虑过在数据库中的常用列上添加索引?
400 seconds is a huge amount of time for a query - have you looked into adding indexes on commonly used columns in your db?
这篇关于致命错误:超过了400秒的最大执行时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!