[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: SQL question about performance...

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:

I think the answer is probably "it depends".

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

Reply to: