[BioSQL-l] BioSQL seqfeature_qualifier_value optimization

Dmitry Samborskiy samborsky_d at yahoo.com
Thu Mar 8 22:19:20 UTC 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