TickTackk
Well-known member
Currently when running this query:
when
SQL:
SELECT MAX(post_date) AS last_post_date, user_id, post_id
FROM xf_post
ORDER BY last_post_date
LIMIT 500
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