Announcement

Collapse
No announcement yet.

How are a forum's posts organised within the database?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Conrad
    replied
    I am looking to import my forum where we have almost 3mln posts and the table containing them shows 2.05 GB for the "data length" and 1.56 GB for the "index length." On top of that changing from ISO encoding to UTF will inflate those figures somewhat.

    It's going to be a looong import when the time comes, but moving to vB is the best step forward.

    Somewhere down the line it might be useful to split up posts between an archive table where posts older than say 1 year can no longer be edited/moved/etc. (by anyone other than the admin), and a current table that the server is constantly dealing with which would then be much smaller. At least when it comes to big boards with tons of posts.

    Leave a comment:


  • Andy
    replied
    Originally posted by Conrad View Post
    Thanks, guys.

    If the posts table grows to 2-3 GB, will editing large posts be just as quick as with a smaller forum?
    My forum has about 1.2 million posts and editing posts is extremely fast. The post table is .5GB in size.

    Leave a comment:


  • Conrad
    replied
    Thanks, guys.

    If the posts table grows to 2-3 GB, will editing large posts be just as quick as with a smaller forum?

    Many years ago forum software had a pruning feature that admins would use as storage often became an issue, but nowadays storage is of no concern whatsoever, so people will let their forums grow without the need to delete old posts. Will it at some point be a good idea from a technical standpoint for really huge boards to have their posts divided into tables based on time-frame (ex. 1 table for each year or number of years) or other criteria?

    Leave a comment:


  • Andy
    replied
    Originally posted by Conrad View Post
    Since they make up the majority of the database size, are they somehow split into separate tables depending on time-frame for instance, or are all posts ever written on a forum kept in a single table that keeps growing and growing over time?
    The post table keeps growing over time.

    Leave a comment:


  • IBxAnders
    replied
    Very generally speaking, you just have a THREAD table and POST table.

    Leave a comment:


  • Conrad
    started a topic How are a forum's posts organised within the database?

    How are a forum's posts organised within the database?

    Since they make up the majority of the database size, are they somehow split into separate tables depending on time-frame for instance, or are all posts ever written on a forum kept in a single table that keeps growing and growing over time?

Related Topics

Collapse

Working...
X