| 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 harms | 29 Aug |
| • Re: performance key-value - int vs ascii ? | Perrin Harkins | 29 Aug |
| • Re: performance key-value - int vs ascii ? | walter harms | 29 Aug |
| • RE: performance key-value - int vs ascii ? | Martin Gainty | 29 Aug |
