List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:August 29 2008 3:32pm
Subject:RE: performance key-value - int vs ascii ?
View as plain text  
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
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

?
Martin 
______________________________________________ 
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: wharms@stripped
> To: perrin@stripped
> CC: mysql@stripped
> Subject: Re: performance key-value - int vs ascii ?
> 
> thx,
> the results support my suspect
> 
> re,
>   wh
> 
> 
> Perrin Harkins schrieb:
> > On Fri, Aug 29, 2008 at 4:57 AM, walter harms <wharms@stripped> 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=1
> 

_________________________________________________________________
See what people are saying about Windows Live.  Check out featured posts.
http://www.windowslive.com/connect?ocid=TXT_TAGLM_WL_connect2_082008
Thread
performance key-value - int vs ascii ?walter harms29 Aug
  • Re: performance key-value - int vs ascii ?Perrin Harkins29 Aug
    • Re: performance key-value - int vs ascii ?walter harms29 Aug
      • RE: performance key-value - int vs ascii ?Martin Gainty29 Aug