As data capacity is skyrocketing nowadays (blue ray, even email accounts are now given limits in gigabytes and not megabytes, pendrives with 8 gigs, etc.), purging posts to create space is no longer an issue.
The Posts table is by far the largest in the database, and this can bog the server down as the table shoots past 1.5GB worth of posts.
Wouldn't a good way forward be for the forum software to create a separate posts table for each calendar year?
This way the entire board wouldn't be based on a single posts table which can reach massive proportions over time, but would instead be neatly organized by year: ubbt_POSTS_2008 , ubbt_POSTS_2009 , ubbt_POSTS_2010 , etc.
The search engine would also have it easy in terms of search dates and which table to sift through.
