1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Query Counts for XF, vB4, vB5, IPB etc.

Discussion in 'General XenForo Discussion and Feedback' started by Digital Doctor, Jan 9, 2013.

  1. Digital Doctor

    Digital Doctor Well-Known Member

    ====Query counts =====
    vB5: 57 queries, 11.79 seconds.
    vBulletin 5 beta 11 - 94-101 queries
    vBulletin 5 beta 10 - 110 queries
    vBulletin 5 beta 14 - approx. 60 queries
    vBulletin 4 - 14 queries
    Xenforo 1.1x - 11 queries forum home
    Xenforo 1.1x - 11 queries on a 1 page thread
    Xenforo 1.1x - 11 queries on a 38 page thread
    Xenforo 1.1x - as low as 6-7 queries (with optimizations)
    IPB - 123 queries for page 2 with a topic containing 400 posts and 61 followers
    IPB - 49 queries on a 2 page thread (note)
    - 103 queries to show a thread that is 123 pages. (note)
    - 8 queries to show the main forum index page (note)

    Comparison issues: quality of the query. (There are queries that are more "expensive" than others !)(ie. number of queries doesn't explain everything)
     
    Adam Howard, DeltaHF and Allan like this.
  2. Digital Doctor

    Digital Doctor Well-Known Member

    Post your results !
     
  3. Garamond

    Garamond Well-Known Member

    Nice!
     
  4. Robbo

    Robbo Well-Known Member

    I don't understand how they manage to get those high query counts.
     
  5. RobParker

    RobParker Well-Known Member

    Isn't just comparing numbers a bit misleading? Doesn't it depend on what they're doing and how optimised they are?
     
  6. Digital Doctor

    Digital Doctor Well-Known Member

    Not all queries are created equal ... for sure !
    Got any ideas how to get around this limitation ?
     
  7. RobParker

    RobParker Well-Known Member

    You'd need someone with a server to install them all on and perform proper tests. I thought Slavik was doing something like that for XF already?
     
  8. Robbo

    Robbo Well-Known Member

    Comparing numbers is wrong indeed. But those numbers are way freaking high so it doesn't matter how optimized they are.
     
    Adam Howard and digitalpoint like this.
  9. digitalpoint

    digitalpoint Well-Known Member

    It's definitely better to run 10 simple queries than 1 nasty query. But that being said, anywhere remotely close to 100 queries (of any sort) for a single page view is not viable for anything but the smallest sites.

    And like others have said, it really depends on how optimized things are.

    Preface: subtract one query from all numbers to not count the query being run to get ads to display (custom to my setup).

    Some examples:

    http://forums.digitalpoint.com
    Logged in user with vB4: 10 queries
    Guest user with vB4: 7 queries
    Logged in user with XF: 7 queries
    Guest user with XF: 7 queries

    http://tools.digitalpoint.com (basic informational page)
    Logged in user with vB4: 7 queries
    Guest user with vB4: 5 queries
    Logged in user with XF: 3 queries
    Guest user with XF: 3 queries

    Thread with 431 replies
    Logged in user with vB4: 15 queries
    Guest user with vB4: 10 queries
    Logged in user with XF: 8 queries
    Guest user with XF: 8 queries
     
    Adam Howard and Digital Doctor like this.
  10. Adam Howard

    Adam Howard Well-Known Member

    While it is true that no query is created equal.... The more people you have online, the more you'll feel those queries. And I don't know about most of you, but if I have as little as 500 people on the site with about 100 queries for each of those people

    500 people X 100 queries = 50,000 database queries :eek:

    Those queries maybe small little queries and alone they maybe harmless, but they add up regardless.
     
  11. Sheratan

    Sheratan Well-Known Member

    Highest query of my xenforo forum I ever see: 26 queries

    23 add-on, 10 user login. Can't remember how many guest.
     
  12. RobParker

    RobParker Well-Known Member

    Is that really how it works? What about caching of queries?
     
    SneakyDave likes this.
  13. Adam Howard

    Adam Howard Well-Known Member

    We're talking MySQL here (which all the above are using)....

    It really depends on the query being run. But you can't cache every query and usually not even the majority.

    Assuming 1/2 of those were cached you'd still have 25,000 queries. And 500 people shouldn't have that many.
     
  14. Walter

    Walter Well-Known Member

    Only the larger forums have 500 users online concurrently.
    Don't forget that most (if not all) forums calculate the number of users online during a n minute time frame so the actual queries per second are lower.
     
    Lucas and SneakyDave like this.
  15. Digital Doctor

    Digital Doctor Well-Known Member

    anyone know how many queries WBB and IPB4 use ?
     
  16. Tracy Perry

    Tracy Perry Well-Known Member

    On my Linux site using WBB this is what I get (not a baseline WBB site, it has several add-ons installed).

    Screen Shot 2016-01-21 at 12.49.31 PM.png

    I'll see if I can figure out how to get IPS to display it.
     

Share This Page