is below query normal it sometimes takes 27 seconds on some big forum sections which kills performance like crazy
from what i understand it only counts number of threads in certain forums
yes there are alot of threads on my forum but is there anything i can do to optimize this query, there is 1 more but i can live with the other.
Somehow i feel like noone can help me.
PHP Code:
SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1253852688 AND open <> 10, 1, 0)) AS newthread
FROM thread AS thread
WHERE forumid = 1220
AND sticky = 0
AND visible IN (0,1,2)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE thread range forumid forumid 6 119685 Using where
Time Before: 0.24812 seconds
Time After: 3.76783 seconds
Time Taken: 3.51971 seconds
Memory Before: 3,558.711 KB
Memory After: 3,558.566 KB
Memory Used: -0.145 KB
09-25-2009, 11:42 AM
Unoptimized query
Hybrid Mode
