Inefficient Forum Listings

[Sly_Ripper]

Continuing from this topic:

The board index (and I assume any forum listing) grabs every row from forums_forums, this could be 20k sub-forums. The board index should only grab nodes/categories with a parent ID of -1 and then any forums with those results as a parent, and sub-forums of that parent. The only reason I can think of that it's not done this way is to provide the correct "last post" info for the user's permissions. It would be nice to have an option to just limit the "last post" depth to 1 sub-forum deep and have a more performant forum.

Edited July 3, 2023 by Sly_Ripper

[Jim M]

2 hours ago, Sly_Ripper said:

this could be 20k sub-forums.

Do you have a use case which would warrant 20k sub-forums? Think that is an insanely large amount that wouldn't be commonplace.

[Sly_Ripper]

2 minutes ago, Jim M said:

Do you have a use case which would warrant 20k sub-forums? Think that is an insanely large amount that wouldn't be commonplace.

Basically, we create a sub-forum for every PlayStation game so topics stay organised. Similar to how every game on Steam has it's own sub-forum: https://steamcommunity.com/discussions/#games

[Sly_Ripper]

I considered attaching the sub-forums to clubs but forums that are part of a club are still loaded on index/forum views.

An Invision install with clubs enabled are possibly prone to this slowdown, I don't know if the club rows are evaluated or not.

Edited July 3, 2023 by Sly_Ripper