Originally Posted by Conrad
The Posts table is by far the largest in the database,


I gave it some more thought, and there is a very easy way to almost half the size of the posts table.

The USERS tables are all split up to maximise performance, and you could do the same for the POSTS table. If you would split of the actual content of the post with the UBB Markup code in it, you would end up with 2 smaller tables. The marked up version is only needed when quoting messages and editing posts.

[Linked Image from siemons.org]