| Andreas |
06-15-2009 09:45 AM |
(Utterly) Bad Query
Code:
# Time: 090615 12:01:57
# User@Host: xxx[xxx] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 605 Rows_examined: 784838
use xxx;
SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE post.post_thanks_amount != 0
AND thread.forumid IN(5,20,3,45,8,18,39,1,11,31,46,10,76,25,59,4,14,53,15,54,35,55,36,56,16,58,52,57,19,7,17,13,6,66,47,21,30,23,78,77,80,79,81,82,83,84,85,86,87,88,89,90,91,27,63,71,29,93)
ORDER BY post.dateline DESC
LIMIT 1000;
This is caused by
PHP Code:
$posts = $db->query_read("
SELECT postid
FROM " . TABLE_PREFIX . "post AS post
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.threadid = post.threadid)
WHERE post.post_thanks_amount != 0
AND thread.forumid IN(" . implode(',', $forumids) . ")
ORDER BY post.dateline DESC
LIMIT " . ($vbulletin->options['maxresults'] * 2) . "
");
You might als want to use slave db. |
More Information