threads awaiting moderation Crash!

[SᴩiDᴇЯ]

Originally Posted by kh99

Maybe the easiest thing would be to edit the file modcp/moderate.php and around line 353 change it like this (red added):

	$moderated = $db->query_read("
		SELECT *
		FROM " . TABLE_PREFIX . "moderation
		WHERE type IN ('thread', 'reply')
		LIMIT 100	
	");

I just picked 100 arbitrarily, I have no idea how much larger you could make it (or even if it would have to be smaller than 100).

Hi kh99,

I have done the limit to 1000 and it works fantasticly, thank you very very much I appreciate your help.

see:

$moderated = $db->query_read("
		SELECT *
		FROM " . TABLE_PREFIX . "moderation
		WHERE type IN ('thread', 'reply')
		LIMIT 1000
	");

--------------- Added [DATE]1315759426[/DATE] at [TIME]1315759426[/TIME] ---------------

This was my thread count 15 min ago before i did the moderating: http://screensnapr.com/v/KenboP.png

This is my thread count now after moderating 1000 threads at a time with over 5000+ threads and only took 12 min: http://screensnapr.com/v/XpNbFk.png