View Single Post
  #23  
Old 05-20-2004, 01:37 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Pseudomizer
Hi San-Deep,

i am glad that you installed the hack. When i look at your page then it seems for me that your board is running fine. You have high PHP and low MySQL usage. This shows that it has nothing to do with any queries.

The 2 templates which are not cached should not be a big problem. But the fix for this is very easy: Open the PHP file in an editor and look for the templates variable in there. Usually the global templates variable. After the last template just add your 2 missing templates by adding -> , <- this comma and in the next line the template name. This will not be a big performance boost but it will cache the template.

By the way: Will all respect, but i have response times from 0,2 seconds and your site is fast enough. Where is the problem ? On any specific subdirectory or php file ? Because at the moment i would say it is fine.

Question: Did you add your microstat variable also into your portal ? It would be nice to see how many queries are run there.

The only conclusion would be: Your server has a problem as soon as multiple users access your page simultaneously. If this is the case then it could be your MySQL database daemon. Which version of MySQL are you using ?

Cheers,
you are simply fast thats great
i opened index.php and global.php both and edited stuff as you directed me to. here is 1 of the changes i have done in index.php file

Original Code
Code:
// pre-cache templates used by all actions
$globaltemplates = array(
 'FORUMHOME',
 'forumhome_event',
 'forumhome_forumbit_level1_nopost',
 'forumhome_forumbit_level1_post',
 'forumhome_forumbit_level2_nopost',
 'forumhome_forumbit_level2_post',
 'forumhome_lastpostby',
 'forumhome_loggedinuser',
 'forumhome_moderator',
 'forumhome_pmloggedin',
 'forumhome_subforumbit_nopost',
 'forumhome_subforumbit_post',
 'forumhome_subforumseparator_nopost',
 'forumhome_subforumseparator_post',
 'forumhome_vbpopup'
);
And Modified Code Check the last line
Code:
  
Original Code
Code:
// pre-cache templates used by all actions
$globaltemplates = array(
 'FORUMHOME',
 'forumhome_event',
 'forumhome_forumbit_level1_nopost',
 'forumhome_forumbit_level1_post',
 'forumhome_forumbit_level2_nopost',
 'forumhome_forumbit_level2_post',
 'forumhome_lastpostby',
 'forumhome_loggedinuser',
 'forumhome_moderator',
 'forumhome_pmloggedin',
 'forumhome_subforumbit_nopost',
 'forumhome_subforumbit_post',
 'forumhome_subforumseparator_nopost',
 'forumhome_subforumseparator_post',
 'forumhome_vbpopup',
);
did changes like that 2 places in index.php and 2 places in global.php but no luck , still it shows 2 uncached templates :S

Microstats on Portal. I am not sure, how to add those there.
But if you want/help we can try out that
I am using Virtuanews -> www.virtuanews.co.uk

Server Type Linux; PHP v4.3.3; Apache v1.3.29
MySQL v4.0.18-standard
PHP Max Post Size 55M
MySQL Maximum Packet Size 16.00 MB
PHP Memory Limit None
Database Index Disk Usage 9.77 MB

Sandy...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01127 seconds
  • Memory Usage 1,781KB
  • 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_code
  • (1)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