Go Back   vb.org Archive > Community Central > Community Lounge
FAQ Community Calendar Today's Posts Search

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

Its a just a thought question.

A set of queries, and how long they each take, under load:

100q, 4 seconds
10q, 40 seconds

Which is better? The query time, is insanely low across the application in vBulletin 5, I know this because I run it on a really crappy atom server in house. I'm not saying there shouldn't be less queries. Less queries, when they're better queries, can be better. But less queries for less queries is not always better.
Reply With Quote
  #22  
Old 05-21-2014, 09:11 PM
nhawk nhawk is offline
 
Join Date: Jan 2011
Posts: 1,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Zachery View Post
Its a just a thought question.

A set of queries, and how long they each take, under load:

100q, 4 seconds
10q, 40 seconds

Which is better? The query time, is insanely low across the application in vBulletin 5, I know this because I run it on a really crappy atom server in house. I'm not saying there shouldn't be less queries. Less queries, when they're better queries, can be better. But less queries for less queries is not always better.
What you said is absolutely correct.

But using your example of 100q, multiply that by 100 clients and now you have a potential problem. Now we both know vB5's queries don't take 4 seconds but the idea is still the same.

Couple that with relying on the clients machine to do a lion's share the work and you end up with a slow system.
Reply With Quote
  #23  
Old 05-21-2014, 09:30 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The client doesn't do that much work in 5, not processing data wise anyway. WE return html via ajax, and other data. Nothing all that weird.
Reply With Quote
  #24  
Old 05-22-2014, 10:11 AM
nhawk nhawk is offline
 
Join Date: Jan 2011
Posts: 1,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any way you look at it, the way vB5 is working, client side rendering creates a heavier initial load with a second request to the server. And then vB5 needs to deal with slower CPUs and rendering engines on the client side. Either one of those is a going to make client side rendering slower.

IE: There's no reason on earth that the vb.com forum should take 8 to 10 seconds to load on initial entry into the forum.
Reply With Quote
  #25  
Old 05-22-2014, 12: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 Zachery View Post
Query count isn't end all be all.

If I can spend .05 seconds doing 100 queries, you'd prefer 10 queries that take .5 seconds?
Thats true up to a point, but if you start to get busy, those 100 queries are going to start to slow down and be a bigger issue because a server can only handle so many at a time.

There is a bug in 5.1.1 which means some pages are running hundreds (sometimes over 1000) on that specific page. That many will very quickly become a major issue if lots of people try to load that page.
Reply With Quote
Благодарность от:
nhawk
  #26  
Old 05-22-2014, 05:05 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 Paul M View Post
Thats true up to a point, but if you start to get busy, those 100 queries are going to start to slow down and be a bigger issue because a server can only handle so many at a time.

There is a bug in 5.1.1 which means some pages are running hundreds (sometimes over 1000) on that specific page. That many will very quickly become a major issue if lots of people try to load that page.
I know, there are also amplification issues, which I believe is what you're talking about.

I want vBulletin 5 to be faster, I've been trying to work on problems where I can, when I can.
Reply With Quote
Благодарность от:
tbworld
  #27  
Old 05-23-2014, 08:07 AM
Spangle Spangle is offline
 
Join Date: Jun 2011
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by katie hunter View Post
But VBulletin developers aren't new graduate college students. The issue here is that we need more, currently I was told we have 4 developers only.



Also there is nothing wrong with new graduate web developers as long as they are graduating from prominent universities like Harvard, Yale and so on, they do have the skills and learn while in college. I guess what I can say is that there are 2 type of web developers, those who relay on everything they learn from college and those who always explore new ideas from outside resources and love to implement unique ideas, the latter is what we need.

Founders of Google, Twitters, Facebook, Disqus and all these unique ideas were new graduate students with visions and ideas that they like to implement and test.
I've voted for all of those, great idea's.

I would also like to see a drop down menu system for the navbar.
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 07:48 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.04099 seconds
  • Memory Usage 2,249KB
  • Queries Executed 14 (?)
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
  • (4)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
  • (2)pagenav_pagelink
  • (7)post_thanks_box
  • (2)post_thanks_box_bit
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (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_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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete