I would say providing a table to retain the users relevant details especially after marking as deleted would be a logical choice
Martin Gainty ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Fri, 3 Oct 2008 18:49:07 +0200 > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > Subject: simple design choice > > 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] > _________________________________________________________________ Get more out of the Web. Learn 10 hidden secrets of Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008