MySQL Performance Example Was: Seriously, WTF?

Andy Wardley abw at
Fri May 9 15:03:30 BST 2008

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?

> 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.


More information about the mailing list