MyBB Community Forums

Full Version: why mybb has only one posts table??
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Some other platform has multiple DB tables of posts.

Does only one-posts table occur delay when the amount of the post becomes greater?
There's no need. The largest MyBB forum has 52M posts, and that's considered small compared to what MySQL can handle.
@alstn13178 from my point of view, there is no need to have more than one posts table... if you run a forum on your own dedicated server with enough power you won't face any problems, you may require to add some smart indexes to the tables so it replays faster. But that's enough.

Plus, 5 posts table wouldn't help to speed up your forum... if you have to show a post from the first table, you will have to run 5 querys until you find it.

How large your posts table is?
Searches are the biggest thing that become problematic with larger forums, however, my Fast Search Plugin addresses that.