last x attachments on index / first x attachments on index
these two scripts create huge temp files causing my mysql to pretty much lock up.
there are a lot of attachments on the board (over gb worth). this is the queries that cause the problem:
Quote:
SELECT a.attach_id, a.topic_id, a.post_msg_id, a.physical_filename, a.real_filename, f.forum_id, t.topic_id, t.forum_id, t.topic_title
FROM ' . ATTACHMENTS_TABLE . ' a, ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
WHERE (mimetype = "image/jpeg" OR mimetype = "image/png")
AND a.topic_id = t.topic_id
AND ' . $db->sql_in_set('t.forum_id', $forum_ary) . '
AND t.forum_id IN (' . $forums . ')
ORDER BY post_msg_id DESC';
$results = $db->sql_query_limit($sqls, $convert_real_size);
Login
Register
FAQ
Search
Members
