MySQL Performance Example Was: Seriously, WTF?

[Andy Wardley]

Christopher Jones wrote:
> The `chr` field is one of the 24 chromosome names, (1..22, 'X', 'Y'), 

Aha, that explains the umpty million rows then.

<teach student="grandma" subject="blowing eggs">
You know about BioPerl and BioPerl DB, right?
</teach>

> at some point I did have it as an ENUM. 

+1 for an ENUM from me.  As others have said, it's fine when you're not
planning to add any values at a later date.

A