From: Martin Gainty
Date: October 3 2008 4:58pm
Subject: RE: simple design choice
List-Archive: http://lists.mysql.com/mysql/214737
Message-Id: <BLU142-W7E6DDAF83D675D83005AEAE3C0@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_71db2c37-f2db-4f34-8fea-b182c11a2aed_"

--_71db2c37-f2db-4f34-8fea-b182c11a2aed_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



I would say providing a table to retain the users relevant details especial=
ly after marking as deleted would be a logical choice

Martin Gainty=20
______________________________________________=20
Disclaimer and confidentiality note=20
Everything in this e-mail and any attachments relates to the official busin=
ess of Sender. This transmission is of a confidential nature and Sender doe=
s not endorse distribution to any party other than intended recipient. Send=
er does not necessarily endorse content contained within this transmission.=
=20


> Date: Fri=2C 3 Oct 2008 18:49:07 +0200
> From: spaceoutlet@stripped
> To: mysql@stripped
> Subject: simple design choice
>=20
> Hello=2C
>=20
> 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.
>=20
> 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.
>=20
> 2) Should I create a new table user_id=2C flag already prefilled with
> all user_ids.
>=20
> 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 th=
e data.
>=20
> Thank you=2C
>=20
> Alex
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!5=
50F681DAD532637!5295.entry?ocid=3DTXT_TAGLM_WL_domore_092008=

--_71db2c37-f2db-4f34-8fea-b182c11a2aed_--