[BioSQL-l] BioSQL seqfeature_qualifier_value optimization

Dmitry Samborskiy samborsky_d at yahoo.com
Thu Mar 8 17:19:20 EST 2007

Hello Everybody,

I use BioPerl-DB and BioSQL project.
I suggest to make one extra index to optimize the search by FT tag values.

On MySQL it could be done with

CREATE INDEX value_ind ON seqfeature_qualifier_value (term_id, value(64));

Best regards,
  Dmitry Samborskiy


Вы уже с Yahoo!? 
Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com

More information about the BioSQL-l mailing list