vBulletin 4 coding quality?

Discussion in 'vBulletin Discussions' started by cheat-master30, Nov 7, 2009.

  1. Peggy

    Peggy Regular Member

    Joined:
    May 18, 2009
    Messages:
    1,641
    Likes Received:
    58
    Re: vbulletin.org (day after tomorrow)

    95 queries... that's insane. Imagine what it'll use when it's filled with content?
     
  2. MjrNuT

    MjrNuT Grand Master

    Joined:
    Oct 14, 2009
    Messages:
    579
    Likes Received:
    36
    Re: vbulletin.org (day after tomorrow)

    how do you say....counter productive?

    Was it too much to expect a streamlined CMS from the get go? Is it really that resource intensive relative to other CMS (actual) products?

    Are we being fair with the assessment of the CMS with these statements on the queries? (If any truth to them, then how consequential are they?)

    Could someone cite some examples since the quotes were using average site?

    (these are my general questions, not pot shots)

    @Shelley, thanks for starting the thread regarding Vborg. I think you boiled it down though correctly, which is the incentive of coders to contribute. I'm sure there will always be contributors. What I ask myself though as if I was one of those coders and was hit (err blind-sided) by the license changes, presale notice, would I still have incentive for vB4?
     
  3. Peggy

    Peggy Regular Member

    Joined:
    May 18, 2009
    Messages:
    1,641
    Likes Received:
    58
    wow.............
     
  4. Shelley

    Shelley Regular Member

    Joined:
    May 26, 2009
    Messages:
    826
    Likes Received:
    61
    Dedicated solutions here we come. lol
     
  5. Slinky

    Slinky Addict

    Joined:
    Nov 5, 2009
    Messages:
    96
    Likes Received:
    6
    Re: vbulletin.org (day after tomorrow)

    1) Regardless of whether there are 95 or 950 queries, vBulletin 4 will launch when Ray says it will, so rejoice!

    2) All of this stuff can easily be fixed over time, and at worst, in vBulletin 5.

    3) If you're really not happy, you can turn off all the extra features of the vBUlletin Suite you paid for and just use a forum and an established CMS like Wordpress, Joomla or Drupal without much fuss. Quite frankly, I realized that 99% of my users won't be using a CMS anyways and I've already been able to skin a header in Wordpress and a forum to look exactly alike with minimum fuss. User integration can be done but is it really needed?
     
  6. Peggy

    Peggy Regular Member

    Joined:
    May 18, 2009
    Messages:
    1,641
    Likes Received:
    58
    Re: vbulletin.org (day after tomorrow)

    My test forum is where Nick got his info. I put it in debug mode.

    The cms queries executed are 96. That is with 3 articles, and 4 widgets added so far. :uhh:
     
  7. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    No offense, but do either of you understand what that statement means?

    That means that the first time the page gets loaded, it runs the 100 queries. Now, think about this for a second.

    That first person, who is more than likely you being the owner of the site, is the unlucky dog. Every person after that, however, will be seeing normal speeds.

    Even my software does this. On a cold cache, ImperialBB will run approximately 40 or 50 queries on the Forum Index when the page is viewed once. After that first initial page view, ImperialBB runs 4 or 5 queries, per page load, on the Index.

    Now, when you think about THAT, it would take approximately 10 people to run the equivalent amount of queries as the cold cache pageload.

    A stock vBulletin runs 11-13 queries on board home. It would take ~10 people to generate the same amount of queries as a cold cache pageload on the CMS.

    If your server is crawling with 10 people browsing the Forum Index, then you have worse problems to worry about than a 100 query single pageload.
     
    2 people like this.
  8. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    If I recall correctly, when I first loaded the CMS page, it was 95 queries. But every time I refresh after that it dropped to - and remained at - 47 queries. Is that what you explained?
     
  9. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    Precisely. It's not possible to autmoatically fetch that information from the Cache, because it doesn't exist there. So vBulletin has to use one pageview to pull it from the database and store it into the cache.

    That 47 queries is only about 8 - 10 queries higher than the new vBulletin profiles, btw.
     
  10. gnatster

    gnatster Regular Member

    Joined:
    May 31, 2009
    Messages:
    717
    Likes Received:
    98
    Location:
    Down the hall
    First Name:
    Nathan
    Thanks for the explanation Ryan.
     
  11. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    You're quite welcome. Even though I'm technically a competitor, I'm still a user of vBulletin. Therefore, I'd rather use my knowledge to help benefit other vBulletin owners as well as the product itself, rather than put down on the product and allow false information to be passed around.

    That's what professionalism is all about, in my humble opinion. :)
     
  12. hotwheels

    hotwheels Champion

    Joined:
    Nov 1, 2009
    Messages:
    287
    Likes Received:
    2
    First Name:
    doug
    Great information ryan, i actually understand how that works...........
     
  13. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    Then you understand why I had to say something. :)
     
  14. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    Yes Ryan, thanks for explaining that. You don't visit too often, but when you do, it's usually with great information. :P
     
  15. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    Does that qualify me for Mentor status? ;D
     
  16. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    If you'd spend more time here, then I don't see why not. :P
     
  17. Peggy

    Peggy Regular Member

    Joined:
    May 18, 2009
    Messages:
    1,641
    Likes Received:
    58
    Thanks for the explanation Ryan. The "wow" was because it does seem high to me.
    However, there is a thread in the alpha/beta forum for this topic. Many people are pulling a fairly high # of queries.
     
  18. Ryan Ashbrook

    Ryan Ashbrook Regular Member

    Joined:
    Jun 29, 2009
    Messages:
    343
    Likes Received:
    25
    Location:
    Cincinnati, Ohio
    Of course, it is high. But you have to consider that it only happens once.

    And I'm just adding to what Kevin said in the developer chat yesterday, I've no clue what other factors are going into vBCMS.

    Well... I am posting here rather than coding on my BBS... so that's gotta say something. xD
     
  19. hotwheels

    hotwheels Champion

    Joined:
    Nov 1, 2009
    Messages:
    287
    Likes Received:
    2
    First Name:
    doug
    absolutely. I appreciate you taking the time to put that into laymens terms......
     
  20. Lynne

    Lynne Regular Member

    Joined:
    May 26, 2009
    Messages:
    333
    Likes Received:
    32
    Location:
    Home Sweet Home!
    Re: vbulletin.org (day after tomorrow)

    Don't forget, Peggy, that they haven't cached the templates yet and that accounts for 20-30 of the queries shown.
     

Share This Page