beacker@stripped wrote:
> mysql> create table gb_locus (
> -> gbl_id int primary key,
> -> gbl_fileID int,
> -> gbl_locus varchar(20),
> -> gbl_size int,
> -> gbl_date date,
> -> gbl_phylum char(3),
> -> gbl_foffset int
> -> );
At a recent MySql class, I learned that using all fixed
length fields instead of variable length fields can improve
speed. This is because MySql can skip thru records faster
if the records are all a fixed length.
So, if you were willing to give up a little storage space,
make the gbl_locus field a Char(20) instead of a varchar(20)
and see if it speeds things up. I found noticable speed
increase in my selects doing this.
