i worked with simHQ (over 2.5 million posts) -- the solution was to just create an archive DB for the 'historical posts'... then allow the 'current posts' which are highly trafficked be part of the primary DB...
works fine and makes speed a non-issue..
