there is a a very big overload problem and there are many long querys.
very much SLEEP with long duration like 0-200. what does it meaN?
and can you explain me this query ? it processes very often and long 10-100 duration
PHP Code:
SELECT threadid, title, prefixid, lastpost, replycount
FROM vbthread AS thread
WHERE forumid =
and
PHP Code:
Sorting result SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount
is it like this link?:
/forumdisplay.php?s=&f=161&page=1&pp=20&sort=views& order=desc&daysprune=2
how to fix?
is it also possible to limit the "&pp=20" part so no one can abuse and slowing down site by visiting this page on "&pp=200" ? or does it make no sense.