The Arcive of Official vBulletin Modifications Site.

Morgalis · #1 07-05-2003, 10:55 PM

My site just got a lot busier, and it's killing my site!

I have quite a few hacks in, nothing truly extravagant though such as karma, rpg, store et al

i have turned on debug mode and for index.php i got

Page generated in 49.8040850163 seconds with 28 queries,
spending 45.3688160181 doing MySQL queries and 4.43526899815 doing PHP things.

so i used Xenon's optimizing and got down to

Page generated in 11.122871995 seconds with 23 queries,
spending 10.1487640142 doing MySQL queries and 0.974107980728 doing PHP things.

i'm attaching the printout of the optimized debug output

i need some fast advice =/

MUG · #2 07-05-2003, 11:08 PM

The hack that shows the number of posts & threads since your last visit is causing problems.

--------------------------------------------------------------------------------

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1057397209'
Time before: 0.556862950325
Time after: 7.43775296211

That query took 7 seconds...

Morgalis · #3 07-05-2003, 11:12 PM

actually i removed that as i saw it [not sure why it all of a sudden is causing problems] and i'm down to

Page generated in 4.09157001972 seconds with 21 queries,
spending 2.20456910133 doing MySQL queries and 1.88700091839 doing PHP things.

Erwin · #4 07-06-2003, 05:57 AM

4 seconds is still a bit slowish. Are you on a shared or dedicated server?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03993 seconds Memory Usage 2,198KB Queries Executed 14 (?)
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)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (1)postbit_attachment (4)postbit_onlinestatus (4)postbit_wrapper (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_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo 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 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 postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!