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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2004, 06:26 AM
K33nny K33nny is offline
 
Join Date: May 2002
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Query count.

I was wondering what I should do about the query count on my forums. I've noticed lately after a few modification's that the count on showthread (going to newest post) is at 40. Here are some average's from different pages:

index.php: 31 queries
forumdisplay.php: 32 queries
showthread.php: 33 queries
showthread.php - latest post: 40 queries
usercp.php: 24 queries

Should I be concerned about the query count being above 30? What could I possibly do to lower the count?

forum.ewplanet.com
Reply With Quote
  #2  
Old 05-02-2004, 08:17 AM
K33nny K33nny is offline
 
Join Date: May 2002
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Access Masks are off by the way.
Reply With Quote
  #3  
Old 05-02-2004, 12:13 PM
Tony G's Avatar
Tony G Tony G is offline
 
Join Date: Nov 2001
Location: Melbourne, Australia
Posts: 8,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Stop installing hacks?

That's the really obvious reason why your queries are increasing. What hacks have you installed?
Reply With Quote
  #4  
Old 05-02-2004, 07:45 PM
K33nny K33nny is offline
 
Join Date: May 2002
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not alot honestly. As you can tell my forums are quite basic.
Reply With Quote
  #5  
Old 05-02-2004, 09:04 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

31 queries for a vb2 index page is really not basic...
iirc basic was 15 queries.

as for showthread, 33 queries can be ok, it depends if these are fast ones or not, i'd suggest to remove some though...

Maybe you have just some hacks which are not well coded.
sometimes you can combine a few queries (take a look at my forumhome optimization for vb2, or a quite similar hack by filburt.)

there are some optimization hacks for vb2 which i suggest to install, or the much better way:
upgrade to vb3
Reply With Quote
  #6  
Old 05-03-2004, 12:22 AM
K33nny K33nny is offline
 
Join Date: May 2002
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't really like vB3, well I like it but it's got too much and I personally don't feel like disabling 75 things that I don't need or want. I'll just have to go back through everything I've installed and maybe remove stuff I don't really need. But honestly, I don't think I have THAT much installed.

I'll have to see though.
Reply With Quote
  #7  
Old 05-03-2004, 01:58 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 K33nny
I don't really like vB3, well I like it but it's got too much and I personally don't feel like disabling 75 things that I don't need or want. I'll just have to go back through everything I've installed and maybe remove stuff I don't really need. But honestly, I don't think I have THAT much installed.

I'll have to see though.
What 75 things do you not like about vBulletin 3?
Reply With Quote
  #8  
Old 05-03-2004, 02:34 AM
K33nny K33nny is offline
 
Join Date: May 2002
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Read my post, I said that I didn't need them or want them. vBulletin2 gets the job done for what I want in a set of forums.

I got some of the pages to go down in query count, still going to work on a few other things.
Reply With Quote
  #9  
Old 05-03-2004, 04:39 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well i also don't like some things in vb3, but the advantages really outweight the disadvantages.

Especially the efficient way of caching and queries...
Reply With Quote
  #10  
Old 05-03-2004, 05:13 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 K33nny
Read my post, I said that I didn't need them or want them. vBulletin2 gets the job done for what I want in a set of forums.

I got some of the pages to go down in query count, still going to work on a few other things.
vBulletin 3 gets the job done alot better at the end of the day and then some

As stefan said the advantages realy kick the disadvantages, if you think there are any, in the bum ^^
Reply With Quote
Reply


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 12:32 AM.


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.04123 seconds
  • Memory Usage 2,247KB
  • 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
  • (2)bbcode_quote
  • (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