[BioSQL-l] Sequence loading in biosql MySQL sooooo long

Eric Pelletier ericp at genoscope.cns.fr
Fri Oct 24 05:53:27 EDT 2003


On Thu, 23 Oct 2003, Hilmar Lapp wrote:

|Hmm - MySQL's query planner srews up completely. The ORDER BY should add a
|millisecond in a very poor implementation, since it is about sorting 10-30
|rows. So much for the world's fastest database ...

I do agree ;->

|Which version of MySQL are you running? I suppose it's a rather recent one,
|as I haven't had that problem with mine (3.23.54).

Server version: 4.0.15a-log
Client version:	Ver 11.18 Distrib 3.23.54, for dec-osf4.0f (alphaev6)

-- 
Eric Pelletier



More information about the BioSQL-l mailing list