[EMAIL PROTECTED] 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]