performance key-value - int vs ascii ?

2008-08-29 Thread walter harms
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

Re: performance key-value - int vs ascii ?

2008-08-29 Thread Perrin Harkins
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 ?

Re: performance key-value - int vs ascii ?

2008-08-29 Thread walter harms
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 ?

RE: performance key-value - int vs ascii ?

2008-08-29 Thread Martin Gainty
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