Re: SQL question about performance...

2006-11-29 Thread Matthew Krauss
Dirk wrote: Hi! (I've asked this before but my account seemed to be deleted for some reason...) I have the choice between VARCHAR(8) and INT(10) to store unsigned crc32 values in hex or as decimal integer. Which one would result in more speed after putting an INDEX on it? VARCHAR(8) or INT(10)?

Re: SQL question about performance...

2006-11-29 Thread Dave Ewart
On Wednesday, 29.11.2006 at 11:51 +0100, Dirk wrote: > Hi! > (I've asked this before but my account seemed to be deleted for some > reason...) > > I have the choice between VARCHAR(8) and INT(10) to store unsigned crc32 > values in hex or as decimal integer. > > Which one would result in more sp