php 脚本会超时吗,PHP脚本超时

我有一个公告板系统的自定义脚本,它计算用户所做的线程数,并相应地更新列.这工作正常,但是对于100,000个用户,它在第一次运行时会超时.

我在查询之前尝试添加以下内容,但它仍然超时(500错误).

参数或者set_time_limit(0);

ignore_user_abort(真);

附加：我在我的vps上使用这个脚本.

查询：

set_time_limit(0);

ignore_user_abort(true);

$db->write_query("ALTER TABLE `".TABLE_PREFIX."users` ADD `numthreads` int(10) unsigned NOT NULL default '0'");

// load users into an array to count number of threads

$query = $db->simple_select("users", "uid");

while($user = $db->fetch_array($query))

{

$users[$user['uid']] = $user;

}

foreach($users as $user)

{

$query = $db->simple_select("threads", "COUNT(tid) AS threads", "uid = '{$user['uid']}'");

// get total number of threads

$numthreads = intval($db->fetch_field($query, "threads"));

$db->update_query("users", array("numthreads" => $numthreads), "uid = '{$user['uid']}'");

}

解决方法:

用这个：

ini_set('max_execution_time', 0);

取代：

set_time_limit(0);

ignore_user_abort(true);

你也可以编辑php.ini：

max_execution_time = 60; //Maximum execution time of each script, in seconds

max_input_time = 60; //Maximum amount of time each script may spend parsing request data

希望这可以帮助.

标签：php,mysql,timeout

来源： https://codeday.me/bug/20190713/1451399.html