[EMAIL PROTECTED] wrote:
Thanks for the heads up on this. Unfortunately the only
varchar is the gbl_locus field, so I'm not sure how much this
would by me for the space.
Thanks again,
Brad Eacker ([EMAIL PROTECTED])
No, it wouldn't save you any space. I
>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.
Thanks for the heads up on this. Unfortunately the only
varchar is the gbl_l
[EMAIL PROTECTED] wrote:
mysql> create table gb_locus (
-> gbl_id int primary key,
-> gbl_fileID int,
-> gbl_locus varchar(20),
-> gbl_sizeint,
-> gbl_datedate,
-> gbl_phylum char(3),
