On Fri, Oct 3, 2008 at 9:49 AM, Alex K <spaceoutlet@stripped> wrote:
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this situation
> does not happen a lot.
> 1) Should I alter my users table and add a delete flag to the users table.
>>> it's easy to update however it uses a lot of unnecessary space.
> 2) Should I create a new table user_id, flag already prefilled with
> all user_ids.
> 3) Should I create a new table called deleted_users that has a user_id
> if this user wants to be deleted.
>>> it's hassle to update but takes into consideration the spareness of the
> Thank you,
#1 Define uses a lot of unnecessary space. I would imagine it would
add not much more than 1 MB to the size of db, depending on column
choice. A decent choice I think.
#3 A compact and clean solution.