List:General Discussion« Previous MessageNext Message »
From:walter harms Date:August 29 2008 8:57am
Subject:performance key-value - int vs ascii ?
View as plain text  
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)         vs    code int      and a second table       code int
value int                   value int                              name char(20)


TIA,
  wh
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