Lack of interest Add index for user_id and post_date in xf_post table

This suggestion has been closed automatically because it did not receive enough votes over an extended period of time. If you wish to see this, please search for an open suggestion and, if you don't find any, post a new one.

TickTackk

Well-known member
Currently when running this query:
SQL:
SELECT MAX(post_date) AS last_post_date, user_id, post_id
FROM xf_post
ORDER BY last_post_date
LIMIT 500
when xf_post has roughly a million rows, the query time is ~7 seconds but after adding an index as user_post_date the query time is less than a second.
 
Upvote 3
This suggestion has been closed. Votes are no longer accepted.
Top Bottom