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: spaceoutlet@stripped
> To: mysql@stripped
> 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/mysql?unsub=1
>
_________________________________________________________________
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
