Re: ENUM and select performance

2002-12-02 Thread DL Neil
Alex, This is a specialised question! Unfortunately, in my experience, it comes down to the phrase YMMV (your mileage might vary) and thus requires you to experiment with your data/machine combinations/etc - good job MySQL makes this quite easy! Can I assume that you have done your (manual)

ENUM and select performance

2002-12-01 Thread Alex Pukinskis
I'm working on a project that involves storing a lot of attributes for individuals (think height, weight, eye color, hair color, skin tone, etc.) and will later require searching on those attributes (i.e. return all blue-eyed people with red hair). I'm trying to figure out how to store all of