MySQL Forum - Tracking Post Count

[eluser]Bogdan Tanase[/eluser]
How about a mysql trigger? on update/delete/insert on "posts" table. On each action do a recount for the user who initiated the trigger.

I've never built a forum, so I'm not sure it's the best way...