Re: MySQL Performance Example Was: Seriously, WTF?

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

On 9 May 2008, at 15:03, Andy Wardley wrote:

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


BioPerl isn't much use for the kinds of things I'm doing. In
fact, I  
haven't ever found any use for it at all....


Chris,