PDA

View Full Version : replying is slow....


Hostc
08-04-2003, 12:24 AM
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=3525explain=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?

filburt1
08-04-2003, 12:27 AM
That massive template caching query is probably killing the server.

Hostc
08-05-2003, 12:06 AM
Huh? where can I remove it at? My server load only stays at 0.4 most of the time

Erwin
08-05-2003, 12:25 AM
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...

Hostc
08-05-2003, 08:41 PM
Thanks, I'll try that.

I have quickreply installed, Support Thread hack installed, and some other ones..