charlesr
07-14-2012, 04:00 PM
# Query_time: 36 Lock_time: 0 Rows_sent: 10 Rows_examined: 9670
SELECT post.postid, post.attach
FROM post AS post
WHERE post.threadid = 31776
AND post.visible = 1
AND post.userid NOT IN (3472,11,4180)
ORDER BY post.dateline
LIMIT 9660, 10;
Seems like a lot of rows examined. Is there an index problem with this query?
If there is, how do I go about tracking it down?
SELECT post.postid, post.attach
FROM post AS post
WHERE post.threadid = 31776
AND post.visible = 1
AND post.userid NOT IN (3472,11,4180)
ORDER BY post.dateline
LIMIT 9660, 10;
Seems like a lot of rows examined. Is there an index problem with this query?
If there is, how do I go about tracking it down?