Improve Topic Counts for Forum?

[eluser]WanWizard[/eluser]
From a performance point of view it would be better to store it in a column of the forums table (and increment that counter when a new topic is created) then to query the DB every time.

Alternatively you could create a forum cache and store it in there. That would also remove the forum table query, giving you more performance.

In general, cache what you can.