Posted by Ed Murphy on 04/16/07 17:41

Igor wrote:

> I currently have two tables:
> 1: users
> id_user
> username
>
> 2: baned_users
> id_user
>
> i tought i could use something like this
> 1: users
> id_user
> username
> is_baned
>
> So would it be better to use two tables like in first example or one
> table like in second example? Offcourse, not many users would be baned
> (i hope). I currently have 59 joins with baned_users table in my
> stored procedures, two of those are executed on every access to the
> website (2xtop 20 users), what way should i use?

I recommend the second method (one table). Using a separate table
should be reserved for situations where a subset of users have
significant amounts of extra data (e.g. blobs for the top 20 users).

[Back to original message]