Don't add those indeces to your forum as it will result in a general slowdown.
It will make these stats appear instantly but you will then have dateline indexed twice in thread and post since it is part of a multi-record index already. You will then have lastactivity indexed on the user table which will then have to be updated on every pageview which can be a bad thing.
It is important to devote optimization to the user side of the forum at the admin panel's cost.
|