Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2002, 12:02 PM
bahamut0 bahamut0 is offline
 
Join Date: Oct 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default a question of queries

hi guys and gals im new to hacking vb and keep seeing this querie thing pop up on hacks about how many it does'nt add.
i have micro stats installed and was wondering if 34 queries for my forum home page is alot?
or what is alot.
my board is brand new i have 7 hacks from here installed and about 4 templete mod's.
only have 3 people there as i just put it up about a week ago.

is this too many or how many should i be looking for or should i not be worried at all right now.
Reply With Quote
  #2  
Old 12-04-2002, 02:17 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, it's ok, but not good.

it should stay below 30...

be sure you have alle templates you ahve used because of the hacks also includet into templatesused var in front of the script.

but don't worry, it's not too bad
Reply With Quote
  #3  
Old 12-04-2002, 03:20 PM
N9ne N9ne is offline
 
Join Date: Feb 2002
Posts: 1,495
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sometimes it also depends on the size of the query...
Reply With Quote
  #4  
Old 12-04-2002, 04:34 PM
bahamut0 bahamut0 is offline
 
Join Date: Oct 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok i guess i'll just stop with the hacks that add queries for now until i learn a little bit about them and my board get's a little busier.

btw this is my newest board.
Hidden Ones
i am also using the vbindex as well.

guess i have to learn about them a little bit.

but thanks for the replies .
Reply With Quote
  #5  
Old 12-05-2002, 01:34 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

34 is not too bad. I run mine with 27, and my forumhome is hacked beyond recognition. Like Xenon said, keep it below 30 if you can. It's the most used page on your site next to showthreads.php.
Reply With Quote
  #6  
Old 12-05-2002, 04:42 PM
bahamut0 bahamut0 is offline
 
Join Date: Oct 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

is tyhere a way to lower the queries without having to uninstall an entire hack?
mabye just stop certain things from being shown.
Reply With Quote
  #7  
Old 12-05-2002, 05:26 PM
N9ne N9ne is offline
 
Join Date: Feb 2002
Posts: 1,495
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you have the welcome panel hack installed, you can remove the queries for showing the avatar, that reduces two queries.

You can combine all 3 PM queries into one.

The Member Count, Posts Count, Threads Count totals to 3 queries, and the newest member is another one...it's up to you what you want to keep and/or remove.

There are plenty of ways to reduce queries on certain pages, but in effect most of the time it will stop something from appearing...
Reply With Quote
  #8  
Old 12-05-2002, 07:09 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

optimizing queries isn't that easy, but often possible, so you need a good coder which can work on your file

ps. don't post your files here, it's not allwowed
Reply With Quote
  #9  
Old 12-05-2002, 07:10 PM
bahamut0 bahamut0 is offline
 
Join Date: Oct 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok thats sounds good my forum right now is'nt busy enough so them welcome panel one's arn't that important right now anyway. thanks for the info.
Reply With Quote
  #10  
Old 12-06-2002, 02:23 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can do the welcome panel with using just templates anyway, no need to have a hack, no extra queries.
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:08 AM.


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.10666 seconds
  • Memory Usage 2,241KB
  • Queries Executed 13 (?)
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
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete