I have migrated a large (~2 million comments, ~80K threads) forum from vBulletin to Drupal 5.8.
I'm using advanced forum. The performance is "very bad". I do not have a lot of experience with Drupal, so I'm trying to figure out the best way to go about fixing the performance problem. It looks like the problem is that Drupal made forums fit into it's architecture (of nodes, comments, and taxonomy), but for a modern forum, that architecture doesn't perform well.
I'm considering creating several tables to track data about the forums (e.g. post counts, last post, etc.) and using something like hook_nodeapi to track this.
Any suggestions? Maybe modules I should look into using?
Thanks for any help,