TheUniqueTiger wrote:It should not be taking 1 minute at all... Max as I can imagine for a forum as big as yours it should take not more than 2-5 secs, if at all it takes that much time... Since I don't have a forum even as big as 100 posts, I'll have to wait for some reviews about how this MOD works on other's moderate-large forums.
After replacing all files with the original once in the archive it looks like it's the gender add-on (contrib/addons/gender) which is the causing the problem. Maybe I made a mistake somewhere, I'll try to change the code again, maybe I made a mistake somewhere...
Edit: I've added my mySQL log, maybe it helps...
Code: Select all
# Time: 071218 12:46:14
# User@Host: *****[*****] @ localhost [127.0.0.1]
# Query_time: 132 Lock_time: 0 Rows_sent: 10 Rows_examined: 211217
SELECT COUNT(DISTINCT p.poster_id) AS count, t.topic_id as t_id, t.topic_title as t_title, f.forum_id AS f_id, f.forum_name AS f_name
FROM phpbb3_posts p, phpbb3_topics t, phpbb3_forums f
WHERE p.topic_id = t.topic_id
AND t.forum_id = f.forum_id
AND p.post_approved = 1 AND f.forum_id NOT IN (3, 6, 43, 51, 52, 54, 55, 56, 57, 58, 85, 86, 87, 88, 89, 90)
GROUP BY t_id
ORDER BY count DESC