[BioSQL-l] BioSQL seqfeature_qualifier_value optimization

[Dmitry Samborskiy]

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