Welcome Guest, Not a member yet? Register   Sign In
A relatively quick survey.
#2

[eluser]Dam1an[/eluser]
You're creating a forum? How did I miss that? Tongue

One option would be to keep it normalized and do the count in real time, but thats not what you're asking, I I'll assume you've decided you're definatly storing the post/thread count

From the 'make it as easy for the user' point of view, I would go with a seperate table, which would have user_id (both PK and FK), thread_count and post_count.
Maing users manipulate their current tables will potentially put off a lot of users (also, as unlikely as it is, what if they already have those columns in the user table, or whatever names you choose)


Messages In This Thread
A relatively quick survey. - by El Forum - 05-25-2009, 11:25 AM
A relatively quick survey. - by El Forum - 05-25-2009, 11:31 AM
A relatively quick survey. - by El Forum - 05-25-2009, 12:05 PM
A relatively quick survey. - by El Forum - 05-25-2009, 12:26 PM
A relatively quick survey. - by El Forum - 05-25-2009, 12:36 PM
A relatively quick survey. - by El Forum - 05-25-2009, 12:41 PM
A relatively quick survey. - by El Forum - 05-25-2009, 12:47 PM
A relatively quick survey. - by El Forum - 05-25-2009, 12:51 PM
A relatively quick survey. - by El Forum - 05-25-2009, 01:18 PM
A relatively quick survey. - by El Forum - 05-25-2009, 01:26 PM



Theme © iAndrew 2016 - Forum software by © MyBB