The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
replying is slow....
Don't know why it is.....
Query: SELECT template FROM template WHERE title='options' Time before: 3.0874929428101 Time after: 3.1034179925919 -------------------------------------------------------------------------------- Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059959351 AND sessionhash='d180d7325085322e035bf703fb2503af' AND (host='67.27.181.239' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;' Time before: 3.1087349653244 Time after: 3.1289919614792 -------------------------------------------------------------------------------- Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='157' Time before: 3.1293079853058 Time after: 3.1499669551849 -------------------------------------------------------------------------------- Query: SELECT * FROM thread WHERE threadid=3525 Time before: 3.1506659984589 Time after: 3.1697900295258 -------------------------------------------------------------------------------- Query: SELECT forum.forumid,styleid,styleoverride FROM forum,thread WHERE forum.forumid=thread.forumid AND threadid='3525' Time before: 3.1700479984283 Time after: 3.1885230541229 -------------------------------------------------------------------------------- Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='17' Time before: 3.1886739730835 Time after: 3.2090419530869 -------------------------------------------------------------------------------- Query: SELECT template,title FROM template WHERE (title IN ('quotereply','newpost_postpreview','email_notify' ,'emailsubject_notify','redire ct_postthanks','email_moderator','emailsubject_mod erator','threadreview','thread reviewbit','newpost_attachment','newpost_disablesm iliesoption','forumrules','new reply','posticons','posticonbit','vbcode_smilies', 'vbcode_smiliebit','vbcode_smi lies_getmore','vbcode_buttons','vbcode_sizebits',' vbcode_fontbits','vbcode_color bits','newthread_closeopen','gobutton','timezone', 'username_loggedout','username _loggedin','phpinclude','headinclude','header','fo oter','forumjumpbit','forumjum p','nav_linkoff','nav_linkon','navbar','nav_joiner ','pagenav','pagenav_curpage', 'pagenav_firstlink','pagenav_lastlink','pagenav_ne xtlink','pagenav_pagelink','pa genav_prevlink') AND (templatesetid=-1 OR templatesetid=17)) ORDER BY templatesetid Time before: 3.2092169523239 Time after: 4.5544890165329 -------------------------------------------------------------------------------- Query: SELECT * FROM usergroup WHERE usergroupid=6 Time before: 4.5742700099945 Time after: 4.5899749994278 -------------------------------------------------------------------------------- Query: SELECT parentlist FROM forum WHERE forumid='61' Time before: 4.5908999443054 Time after: 4.6100889444351 -------------------------------------------------------------------------------- Query: SELECT *,INSTR(',61,60,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM forumpermission WHERE usergroupid=6 AND (forumid='61' OR forumid='60' OR forumid='-1') ORDER BY ordercontrol LIMIT 1 Time before: 4.6102830171585 Time after: 4.6310399770737 -------------------------------------------------------------------------------- Query: SELECT * FROM forum WHERE forumid='61' Time before: 4.6314250230789 Time after: 4.6518249511719 -------------------------------------------------------------------------------- Query: SELECT vote, threadrateid FROM threadrate WHERE userid = 157 AND threadid = '3525' Time before: 4.6520010232925 Time after: 4.6715849637985 -------------------------------------------------------------------------------- Query: SELECT template FROM template WHERE title='newreply_ratethread' AND (templatesetid=-1 OR templatesetid=17) ORDER BY templatesetid DESC LIMIT 1 Time before: 4.6717920303345 Time after: 4.6900910139084 -------------------------------------------------------------------------------- Query: SELECT * FROM forum WHERE forumid='60' Time before: 4.6907149553299 Time after: 4.7056659460068 -------------------------------------------------------------------------------- Query: SELECT template FROM template WHERE title='threadreviewbit_ignore' AND (templatesetid=-1 OR templatesetid=17) ORDER BY templatesetid DESC LIMIT 1 Time before: 4.7062740325928 Time after: 4.72207903862 -------------------------------------------------------------------------------- Query: SELECT IF(post.userid=0,post.username,user.username) AS username, post.pagetext,post.allowsmilie,post.userid FROM post LEFT JOIN user ON user.userid=post.userid WHERE post.visible=1 AND post.threadid='3525' ORDER BY dateline DESC LIMIT 11 Time before: 4.7223960161209 Time after: 4.7383519411087 -------------------------------------------------------------------------------- Query: SELECT smilietext,smiliepath FROM smilie Time before: 4.7386929988861 Time after: 4.752210021019 -------------------------------------------------------------------------------- Query: SELECT usergroupid FROM user WHERE userid=157 Time before: 4.7552620172501 Time after: 4.7683579921722 -------------------------------------------------------------------------------- Query: SELECT template FROM template WHERE title='newthread_closeopen' AND (templatesetid=-1 OR templatesetid=17) ORDER BY templatesetid DESC LIMIT 1 Time before: 4.7685149908066 Time after: 4.78293800354 -------------------------------------------------------------------------------- Query: SELECT iconid,iconpath,title FROM icon ORDER BY iconid Time before: 4.7831009626389 Time after: 4.7935470342636 -------------------------------------------------------------------------------- Query: SELECT title, smilietext, smiliepath FROM smilie Time before: 4.7958040237427 Time after: 4.8103699684143 -------------------------------------------------------------------------------- Query: SELECT findword, replaceword, replacementsetid FROM replacement WHERE replacementsetid IN(-1, '16') ORDER BY replacementsetid, replacementid DESC Time before: 4.8198360204697 Time after: 4.83387196064 -------------------------------------------------------------------------------- Page generated in 4.8163349628448 seconds with 22 queries, spending 1.7008098363876 doing MySQL queries and 3.1155251264572 doing PHP things. Query: UPDATE session SET lastactivity=1059960251,location='/forum/newreply.php?s=&action=newreply&threadid=3525expla in=1&showqueries=1',styleid=17 WHERE sessionhash='d180d7325085322e035bf703fb2503af' Time before: 4.8405610322952 Time after: 4.8531060218811 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1059960251,inforum='61' WHERE userid='157' Time before: 4.8532170057297 Time after: 4.872190952301 Can you see anything that would make it slow down? |
#2
|
|||
|
|||
That massive template caching query is probably killing the server.
|
#3
|
|||
|
|||
Huh? where can I remove it at? My server load only stays at 0.4 most of the time
|
#4
|
||||
|
||||
I don't think that would be the cause. Your server load is only 0.4, you say. Your showthread looks unhacked. Try disabling thread rating - that only takes off 1 query, but if you don't use it...
|
#5
|
|||
|
|||
Thanks, I'll try that.
I have quickreply installed, Support Thread hack installed, and some other ones.. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|