Dave, Gizmo,
How about a different database table for each forum as opposed to one for all posts?
When a board grows, it's the posts table that surpasses the rest in terms of size.
Or what about allowing the admin to create new forums with a tickbox to use a different table for it?