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

Reply
 
Thread Tools Display Modes
  #21  
Old 04-24-2006, 05:20 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Theres no one worst hack, however 300+ hacks could be disasterous.

You really need to scale back properly.
Reply With Quote
  #22  
Old 04-24-2006, 05:31 PM
bashy bashy is offline
 
Join Date: Nov 2005
Posts: 2,544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Surely there are some hacks worse for queries than others?
for examply people have promptly said about VB shout...

The thing is all the hacks i have installed are being used in 1 way or an other,
I have removed about 10 - 20 hacks over the last few days, ones that werent
really used or were installed to test it out....

I was always led to beleive that the PsiStats were server intensive, so i disabled
this only to find no difference lol

When debug mode is on what does the (3) mean next to the template, (3) is
just an example, There is one thst (74) i think it is?
Reply With Quote
  #23  
Old 04-24-2006, 05:46 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Many times hacks can be fine tuned.
- uncached templates
- limit what page hacks show on vs. many pages.
- use links to open new pages w/ extra info vs. all the stuff on 1 page.

I have 30-40 products @ the moment and MAX at 21 queries on a few pages AVJ. 12 on most.
Reply With Quote
  #24  
Old 04-24-2006, 05:48 PM
kurtbarker kurtbarker is offline
 
Join Date: Nov 2005
Location: Kogarah, NSW
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

60 does sound a few 2 many...

what would you say is a 'safe' number of queries.

Before I read this thread I didn't even know about debug mode, and I wouldn't have known if 60 queries was good or bad...

I've just checked my forum and i'm running 11 queries on forum home, 18 on forum display, and 13 on show thread.

How would you rate those figures?

Thanks guyz
Reply With Quote
  #25  
Old 04-24-2006, 05:51 PM
bashy bashy is offline
 
Join Date: Nov 2005
Posts: 2,544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So...would 3 uncached templates cause a lot of issues or aint either here nor there?
Reply With Quote
  #26  
Old 04-24-2006, 11:47 PM
Mark.B Mark.B is offline
Senior Member
 
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I run about 30 hacks (including BOTH arcades) and forumhome queries run at 22 which seems to be fine.

I have an entirely unnecessary but nice hack on the front page that adds 3 queries so if I ever had any issues I could easily drop to 19.
Reply With Quote
  #27  
Old 04-24-2006, 11:55 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kurtbarker
what would you say is a 'safe' number of queries.
As a rough guide - when you reach 20 it's worth looking at why, as that's an upper amount. Past 25 and you should start to question if there is a problem, 30+ will almost certainly be the sign of a problem hack or hacks and start to affect performance.
Reply With Quote
  #28  
Old 04-25-2006, 12:08 AM
KMxRetro KMxRetro is offline
 
Join Date: May 2005
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Everyone is telling you the same thing.

There is no way in hell that 100 hacks are being used by 584 members. Let alone 200. You need to stop "being a sucker for new toys" and run your site as if you want people to come back. Your forum index looks like you've taken every possible thing you could ever use and just gone "that'll do" and thrown it in.

I don't even know what your site is about.

A few pointers:-
- REMOVE SOME DAMN HACKS. You don't need 200. I have twice as many members, and they don't need 200 hacks.

- REMOVE some forums. You have SIXTY ONE forums - and that isn't counting subforums. Of course your server load is going to be high. I'm no vBulletin expert, but I'm assuming that would create at least a few extra queries. For example, do you really need a forum for each different type of Pay TV hack? If you only have like 10 posts in five related forums, stick them together and have 50 in one. It looks busier, which will draw more people in.

- Your page is taking 9.8 seconds to be GENERATED. Not downloaded. Not displayed, but generated. That's 9.8 seconds that I have to wait before your page even starts to display in my browser. If I wasn't purposefully trying to check your site out so I could help you out, I would have left by then.

In short dude, your attitude pretty much bites in this topic. You say "which are the most server intensive hacks?", everyone says "you have a gazillion hacks, no wonder...", you say "yes, but which ones are the most server intensive?"

The answer is simple. It isn't the quality of the hacks, or the amount of resources that each one uses, its the fact that you have 200 hacks that you don't need. Your site could easily run without ANY hacks other than the portal mod. Do yourself a favour and listen to these good people.

And I pray that you aren't using a shared host. Think of the other customers who are trying to run their site and are getting massive delays thanks to your love of "toys"...you wouldn't like it. Be responsible.
Reply With Quote
  #29  
Old 04-25-2006, 03:04 AM
kurtbarker kurtbarker is offline
 
Join Date: Nov 2005
Location: Kogarah, NSW
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bashy, I wanna be serious with you for a minute, so please take the time to read this.

I visited your site, and I wouldn't be suprised if people are leaving as soon as they go there, you have way to many. I saw your thread for a new moderator and the postbit is MASSIVE for you. Like triple the size of any postbit i've seen.

I have to agree with what was said earlier, you're instaling everything.

I for one would be happy to help you go through your hacks, tell you what I wouldn't recommend keeping, and see if you agree.

I would encourage you to think about this, 9 seconds for generation is way to much. I'll help you uninstall or whatever if you want the help, but I wouldn't recommend leaving it as is.

Anyway let me know if you want a hand, and maybe someone else would be willing to help.

All I know is that there are so many helpful hacks, and you've just gone way overboard.

Kurt Barker
Administrator - Commodore Life Forums
Reply With Quote
  #30  
Old 04-26-2006, 02:58 PM
robert_2004 robert_2004 is offline
 
Join Date: Sep 2004
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

"statistics - top 5" ==== this is useless and shit. on most forums, it's always got the same members. drop it.

- get rid of all the moving text, especially in the title.
- get rid of the random arcade games box, or at least clean the code and cut down the queries to not display so much info about each arcade game - no one (member or guest) gives a crap about any of that info.
- popular keywords and tags - useless. it doesn't make sense what they are, and i wouldn't use them personally if i was a member.
- the actual forum listing's tables are ++++ed.. all the widths are wrong sizes, needs a lot of fixing.
- go change the settings for Vb - make sure the views for threads are only updated every 'x' hours.
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 01:57 PM.


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.05259 seconds
  • Memory Usage 2,255KB
  • 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
  • (1)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
  • (4)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_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