Posted by Ben Holness on 05/04/06 04:31

> However, for only 500 items I'd say just use the varchar. As Toby said, if you
> index this column (automatic if it's the primary key), it should be very fast.

Based on the first email, I will choose int or enum. I am looking to
squeeze as much efficiency as possible out of the hardware :) I will be
happy shaving off 2 microseconds of cpu processing time.

So which do you think takes the least processor time - PHP looking up a
value in an array or MySQL converting enum to int? ;)

Cheers,

Ben

[Back to original message]