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]