Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page Reducing Queries
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2004, 12:04 AM
ChrisLM2001 ChrisLM2001 is offline
 
Join Date: May 2003
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Reducing Queries
Can someone point to me who had a hack that reduces forumhome's queries down by 2? Think it was Erwin who showed how it was done, but I can't seem to find that thread.

Currently have 9 queries and no uncached templates. But I had it down to 7 before with that mod (it's a new install to test new hacks, so don't want to reimport an already modded copy of vB).

With 9 queries it's taking 0.05 seconds to generate the page, but with 7 that can come down to 0.03.

Chris
Reply With Quote
  #2  
Old 11-26-2004, 02:45 AM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
was this a vb2 hack?
Reply With Quote
  #3  
Old 11-26-2004, 02:55 AM
ChrisLM2001 ChrisLM2001 is offline
 
Join Date: May 2003
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Don't believe it was, since I used it on 3.0.1.

Got it off of a thread where members were trying to get templates cached (why Erwin came to mind, with caching his Microstats templates).

It eliminated 2 extra queries and knocks off around 0.02 off the page generation time.

Just can't find that thread now. Would like to rebump it, as it's a little optimization that does the trick.

Chris
Reply With Quote
  #4  
Old 11-26-2004, 01:13 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
hmm, i don't know that hack.

normally the require global.php already takes 8 queries, so it would be hard to get to 7 with just changing index.php queries.

i may be wrong, but i don't think so ^^
Reply With Quote
  #5  
Old 11-26-2004, 02:38 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ChrisLM2001
Don't believe it was, since I used it on 3.0.1.

Got it off of a thread where members were trying to get templates cached (why Erwin came to mind, with caching his Microstats templates).

It eliminated 2 extra queries and knocks off around 0.02 off the page generation time.

Just can't find that thread now. Would like to rebump it, as it's a little optimization that does the trick.

Chris
9 quierys is nothing to be worried about
Reply With Quote
  #6  
Old 12-01-2004, 01:59 AM
ChrisLM2001 ChrisLM2001 is offline
 
Join Date: May 2003
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Zachery
9 quierys is nothing to be worried about
Found it! Erwin was the correct author, but it wasn't about templates itself....

Total Number of Users Online Now on Every Page
https://vborg.vbsupport.ru/showthread.php?t=59722

Little hack can reduce the index.php queries down by 1 or 2.

Chris
Reply With Quote
  #7  
Old 12-01-2004, 02:01 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ChrisLM2001
Found it! Erwin was the correct author, but it wasn't about templates itself....

Total Number of Users Online Now on Every Page
https://vborg.vbsupport.ru/showthread.php?t=59722

Little hack can reduce the index.php queries down by 1 or 2.

Chris
as i said 9 is nothing to worry about
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 07:00 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03981 seconds
  • Memory Usage 2,214KB
  • 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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete