From: walter harms
Date: August 29 2008 1:30pm
Subject: Re: performance key-value - int vs ascii ?
List-Archive: http://lists.mysql.com/mysql/214295
Message-Id: <48B7F9E8.40102@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
> 
>