Thread: Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)
View Single Post
  #167  
Old 12-20-2008, 11:25 AM
tmc tmc is offline
 
Join Date: May 2008
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by logicuk View Post
Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??
This is just plain wrong.. You don't even explain if it's on the EXACT same page. Seems to me like your website is adding extra queries per post or per thread, (I don't know what script you're taking this info from) and you happen to be comparing different pages.

It's not possible that this mod added 21 queries.

That being said, you really need to hire somebody to fix those query issues and the amount of memory being taken up. I don't quite get how the page you're loading is taking 16MB of memory...

Here's a SHOWTHREAD example:
Quote:
Page generated in 0.02043104 seconds (73.73% PHP - 26.27% MySQL) with 6 queries 2,085.35KB Used
and FORUMHOME:
Quote:
Page generated in 0.01459694 seconds (66.00% PHP - 34.00% MySQL) with 5 queries 1,470.00KB Used
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01099 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete