On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote: > Hello, > > 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 >>> data. > > Thank you, > > Alex
#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. #2 Yuck. #3 A compact and clean solution. -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]