[RSS Feed/News] Add use index to merge posts query

[XenForo]

In large thread merging posts query took long time in some environment:
Code:

analyze
    -> SELECT post_id, post_date, user_id, username, reaction_score, reactions
    -> FROM xf_post
    -> WHERE thread_id = 14369
    -> ORDER BY post_date
    -> LIMIT 1;

+------+-------------+---------+-------+-------------------------------------------------------------+-----------+---------+-------+---------+------------+----------+------------+-------------+
| id   | select_type | table   | type  |...

Read more

ادامه مطلب...