Details
-
Improvement
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
3.1.2
-
None
Description
The page UCPs front page is quite slow, due to a query on the topics table that does not use an index:
SELECT t.* , tp.topic_posted, tt.mark_time, ft.mark_time AS forum_mark_time
|
FROM community_topics t LEFT JOIN community_topics_posted tp ON (tp.topic_id = t.topic_id
|
AND tp.user_id = ***) LEFT JOIN community_topics_track tt ON (tt.topic_id = t.topic_id
|
AND tt.user_id = ***) LEFT JOIN community_forums_track ft ON (ft.forum_id = t.forum_id
|
AND ft.user_id = ***)
|
WHERE t.topic_type = 3
|
AND t.forum_id IN (***)
|
ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC
|
Before: 0.25902s | After: 0.78104s | Elapsed: 0.52203s