Welcome Guest, Not a member yet? Register   Sign In
MySQL Forum - Tracking Post Count
#1

[eluser]TheFuzzy0ne[/eluser]
Hello, everybody!

I'm creating a simple forum which uses MySQL as the database, and I'm wondering what the best method for tracking users' post count should be. I've never built a forum before, but I would like to get it right the first time round. I'm unsure whether MySQL should count the posts on each page load, or whether I should cache the post count for the user in the database. Caching the post count is more efficient on resources, but it does mean that I need to remember to update the post count whenever a post is deleted or inserted. I'm not sure if this is an acceptable way to build a database.

I'd appreciate everybody's opinion on the subject.

Thanks.


Messages In This Thread
MySQL Forum - Tracking Post Count - by El Forum - 01-13-2009, 06:07 AM
MySQL Forum - Tracking Post Count - by El Forum - 01-13-2009, 06:15 AM
MySQL Forum - Tracking Post Count - by El Forum - 01-13-2009, 06:28 AM



Theme © iAndrew 2016 - Forum software by © MyBB