[]Astaran said:
As JustDave said, moving the posts from one subforum to another won't speed up the forum that much. To get a real speed improvement, you'll have to archivate the posts into a different table. [/]
well this is the theory. See the numbers of my test, you can try that on other people's board.
My speed test is very clear. Unless you can show that this is due to some fluke in my setup or non-optimal mslq setup.
Until then it seems proven to me that the forum size is of utmost importance. And I still strongly suspect that indexing based on an integer number for day or week will give maior improvement on recent todays or this week's posts.
Database specialists, please speak up!