Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 08-04-2003, 12:24 AM
Hostc
Guest
 
Posts: n/a
Default 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?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:52 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03266 seconds
  • Memory Usage 2,199KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete