keyla31
09-26-2013, 04:26 PM
My server guy sent me this has the main thing running in vbulletin slowing my site down, but i dont know what it is, please advise:
Copying to tmp table | SELECT
IF(a.votenum >= 1, a.votenum, 0) AS votenum,
IF(a.votenum >= 1 AND a.votenum > 0, a.votetotal / a.votenum, 0) AS voteavg,
a.*, fd.extension AS extension, IF(r.attachrateid >= 1, 1, 0) AS hasvoted,
p.title AS posttitle, p.postid, u.username, p.threadid, t.title AS threadtitle, b.title AS blogtitle, b.blogid
FROM attachment AS a
LEFT JOIN post AS p
ON (a.contenttypeid = 1 AND a.contentid = p.postid)
LEFT JOIN user AS u
ON (a.userid = u.userid)
LEFT JOIN thread AS t
ON (a.contenttypeid = 1 AND p.threadid = t.threadid)
LEFT JOIN blog AS b
ON (a.contenttypeid = 15 AND a.contentid = b.blogid)
LEFT JOIN filedata AS fd
ON (fd.filedataid = a.filedataid)
LEFT JOIN attachrate AS r
ON (a.attachmentid = r.attachid AND r.userid = '0')
WHERE fd.extension IS NOT NULL
AND (t.forumid IN (118,119,120,7,71,72,73,155,156,6,117,31,154) OR a.contenttypeid != 1)
ORDER BY voteavg DESC, a.attachmentid DESC
LIMIT 5050, 50 |
--------------- Added 1380217373 at 1380217373 ---------------
FOUND it, its the attachment gallery mod i put on there, it slows down the site dramatically.
Copying to tmp table | SELECT
IF(a.votenum >= 1, a.votenum, 0) AS votenum,
IF(a.votenum >= 1 AND a.votenum > 0, a.votetotal / a.votenum, 0) AS voteavg,
a.*, fd.extension AS extension, IF(r.attachrateid >= 1, 1, 0) AS hasvoted,
p.title AS posttitle, p.postid, u.username, p.threadid, t.title AS threadtitle, b.title AS blogtitle, b.blogid
FROM attachment AS a
LEFT JOIN post AS p
ON (a.contenttypeid = 1 AND a.contentid = p.postid)
LEFT JOIN user AS u
ON (a.userid = u.userid)
LEFT JOIN thread AS t
ON (a.contenttypeid = 1 AND p.threadid = t.threadid)
LEFT JOIN blog AS b
ON (a.contenttypeid = 15 AND a.contentid = b.blogid)
LEFT JOIN filedata AS fd
ON (fd.filedataid = a.filedataid)
LEFT JOIN attachrate AS r
ON (a.attachmentid = r.attachid AND r.userid = '0')
WHERE fd.extension IS NOT NULL
AND (t.forumid IN (118,119,120,7,71,72,73,155,156,6,117,31,154) OR a.contenttypeid != 1)
ORDER BY voteavg DESC, a.attachmentid DESC
LIMIT 5050, 50 |
--------------- Added 1380217373 at 1380217373 ---------------
FOUND it, its the attachment gallery mod i put on there, it slows down the site dramatically.