XF 1.4 Which will perform better ?

[tonnyz]

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 ) 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

 

[Mike]

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.

 

[tonnyz]

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.

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

 

[Mike]

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

 

[Daniel Hood]

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

 

[tonnyz]

@Mike

thx , Mr Ninja

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

@bold
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.

 

[Daniel Hood]

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

 

[tonnyz]

for overall performance ? nice ! thanks