Jump to content

[Suggestion] Scalability: One db-table per forum


Guest W13

Recommended Posts

Posted

In the future, would it be wise to break the ibf_posts table down so it isn't so huge? How about one table per forum.

I can already think of the problems (searching, moving topics, etc.)

Thoughts?

Posted

that'd be hugely complicated to do but i guess not impossible (just a entire ipb rewrite :P). I think over the long of it, it would actually work out to be less efficient as your using more resources to gather data, especially for example the search engine it'd have to query possible up to dozens of tables.

Posted

Wouldn't work for our board as we've got two thirds in just one of the forums, and it's not really possible to break it up further.

We used SNITZ before, ASP solution, they had one table for archived posts and another for archived topics. Click on a symbol on the board index next to the forum name in order to access the archived posts in that forum. Options for regular archiving or you could just manually archive based on dates. On the advanced search there was an option to include the archive in the search. Perhaps introducing an archive would add too much complexity though.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...