[Aforo]

I had problems with forum prune in a big forum (near 100.000 topics).

It was too slow and more of the times prune doesn't work and I had the error of "too many conections"... and database was stoped several times. This situation was repeated some times, even when we work at low traffic time without good result.

I resolved it changing the SQL query.

includes/phpBB/prune.php around 35 line:

Quote:

//
// Those without polls and announcements ... unless told otherwise!
//
//$sql = "SELECT t.topic_id FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t
// WHERE t.forum_id = $forum_id
// $prune_all
// AND ( p.post_id = t.topic_last_post_id OR t.topic_last_post_id = 0 )";

$sql = "SELECT t.topic_id FROM " . POSTS_TABLE . " p LEFT JOIN " . TOPICS_TABLE . " t ON p.post_id = t.topic_last_post_id
WHERE t.forum_id = $forum_id $prune_all ";

I tested it and near 100 times more quick.