RE: performance key-value - int vs ascii ?
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: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: mysql@lists.mysql.com > 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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > _ See what people are saying about Windows Live. Check out featured posts. http://www.windowslive.com/connect?ocid=TXT_TAGLM_WL_connect2_082008
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
Re: performance key-value - int vs ascii ?
On Fri, Aug 29, 2008 at 4:57 AM, walter harms <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
performance key-value - int vs ascii ?
Hi list, I need to store what is basically a key-value pair. A few years ago i would have choosen an integer as key and used a translation table to get the name (char[]) for the key. Since diskspace is plenty i thinking about to use the name directly. does anyone has any idea what is the performance penalty ? in short: name char(20) vscode int and a second table code int value int value int name char(20) TIA, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]