>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_locus field, so I'm not sure how much this would by me for the space. Thanks again, Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]