I've temporarily resolved most of the slowness in the main index page by disabling the display of new thread and new post counts. However, I still suspect that the ultimate solution to the performance problem must be archiving of old posts so that the active w3t_Posts table is back to a more reasonable size.