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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to