I would do #3.
On 10/3/08, 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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
