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

XF 1.4 Which will perform better ?

Discussion in 'XenForo Questions and Support' started by tonnyz, Mar 24, 2015.

  1. tonnyz

    tonnyz Member

    Hi, just out of my interest.

    Let's say Domain A and Domain B have 1 million threads listed inside it, each.

    Domain A distributes its threads to 50 different forums/subforums. While Domain B piles them all inside 1 (yes "1", the only o-n-e :D) forum node.

    Performance wise, which domain will perform faster/more efficiently ? Will it be a significant difference ?

    Any words / other considerations (aside from the performance) will be appreciated, thx :D
  2. Mike

    Mike XenForo Developer Staff Member

    The only real difference will be on the forum view page (showing a list of threads) and there will be better performance if there are fewer threads there, so more nodes would perform there. That said, there are various trade offs so it's probably not a dead simple question.
  3. tonnyz

    tonnyz Member

    @bold: Despite there are only 20 threads for each forum_view page ?
  4. Mike

    Mike XenForo Developer Staff Member

    Yes. There are elements that depend on the total number of threads in the forum (or in the viewable date range, if limited).
    tonnyz likes this.
  5. Daniel Hood

    Daniel Hood Well-Known Member

    Yes. The query looks at the entire table, the other site would perform a little better due to the fact that there are indexes. The index is on the node id; if you have 50 nodes all with the same amount of threads as the site with only one node, then the forum view for the site with 50 nodes is "looking at" 1/50th of the amount of rows as the site with a million all in one node.

    Don't take this as the site with a million threads in one node is going to perform badly, it's just going to execute that query a little slower.

    [Edit] Ninja'd by @Mike
  6. tonnyz

    tonnyz Member


    thx :) , Mr Ninja :p:LOL:

    for a comparison between 1M threads/forum with 1000 threads/forum, could you roughly estimate will the difference of overall performance be just about 1~3 s ? Or more than 10s ?

    Sorry to bother you, I'm considering some changes depend on this. :oops:
    Last edited: Mar 24, 2015
  7. Daniel Hood

    Daniel Hood Well-Known Member

    Yeah... we aren't talking about seconds here, we're talking about like 1/4 second, if that.
    tonnyz likes this.
  8. tonnyz

    tonnyz Member

    for overall performance ? nice ! thanks :D

Share This Page