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 speed after putting an INDEX on it? > VARCHAR(8) or INT(10)? > > ...I use mySQL.. This is the previous thread when you asked before: http://lists.debian.org/debian-user/2006/11/msg02253.html I think the answer is probably "it depends". Dave. -- Please don't CC me on list messages! ... Dave Ewart - davee@sungate.co.uk - jabber: davee@jabber.org All email from me is now digitally signed, key from http://www.sungate.co.uk/ Fingerprint: AEC5 9360 0A35 7F66 66E9 82E4 9E10 6769 CD28 DA92
Attachment:
signature.asc
Description: Digital signature