Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Martin Gainty (mgaintyhotmail.com)
Date: Fri Aug 29 2008 - 10:32:40 CDT
addresses the case for using ENUM over VARCHAR for low cardinality columns
For performance issues on which sort algorithm does a join select is addressed at
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, 29 Aug 2008 15:30:16 +0200
> From: wharmsbfs.de
> To: perrinelem.com
> CC: mysqllists.mysql.com
> Subject: Re: performance key-value - int vs ascii ?
> the results support my suspect
> Perrin Harkins schrieb:
> > On Fri, Aug 29, 2008 at 4:57 AM, walter harms <wharmsbfs.de> wrote:
> >> Since diskspace is plenty i thinking about to use the name directly. does
> >> anyone has any idea
> >> what is the performance penalty ?
> > http://www.mysqlperformanceblog.com/2008/01/24/enum-fields-vs-varchar-vs-int-joined-table-what-is-faster/
> > - Perrin
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgaintyhotmail.com
See what people are saying about Windows Live. Check out featured posts.