From: Martin Gainty
Date: August 29 2008 3:32pm
Subject: RE: performance key-value - int vs ascii ?
List-Archive: http://lists.mysql.com/mysql/214298
Message-Id: <BLU142-W352431725268B226A6852EAE630@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_3c464a9b-dc68-4f6f-909a-59cdc22087c0_"

--_3c464a9b-dc68-4f6f-909a-59cdc22087c0_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


addresses the case for using ENUM over VARCHAR for low cardinality columns

For performance issues on which sort algorithm does a join select is addres=
sed at
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

?
Martin=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 29 Aug 2008 15:30:16 +0200
> From: wharms@stripped
> To: perrin@stripped
> CC: mysql@stripped
> Subject: Re: performance key-value - int vs ascii ?
>=20
> thx=2C
> the results support my suspect
>=20
> re=2C
>   wh
>=20
>=20
> Perrin Harkins schrieb:
> > On Fri=2C Aug 29=2C 2008 at 4:57 AM=2C walter harms <wharms@stripped> wro=
te:
> >> Since diskspace is plenty i thinking about to use the name directly. d=
oes
> >> anyone has any idea
> >> what is the performance penalty ?
> >=20
> > http://www.mysqlperformanceblog.com/2008/01/24/enum-fields-vs-varchar-v=
s-int-joined-table-what-is-faster/
> >=20
> > - Perrin
> >=20
> >=20
>=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

_________________________________________________________________
See what people are saying about Windows Live.  Check out featured posts.
http://www.windowslive.com/connect?ocid=3DTXT_TAGLM_WL_connect2_082008=

--_3c464a9b-dc68-4f6f-909a-59cdc22087c0_--