we have many links like this as buttons:
forumdisplay.php?f=621&prefixid=example
but prefixes arent tags or? we dont even use tags,
i just want to know if this is normal this query what it does and why it comes so often?..
ps. this is ticket answer from server manager coz overload:
Code:
Hello, high load on your mysql server.
Slow querys like this.
Maybe you ca
SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
FROM vbthread AS thread
WHERE forumid = 1101
AND sticky = 0
AND visible = 1
ORDER BY sticky DESC, thread.dateline DESC
LIMIT 177880, 20
Maybe you can try to change database engine to INNODB, but we`re not sure.
Thank you for ticket.
but its also possible the load caused by something else and this querys hang up ?