MySQL Forums
Forum List  »  Full-Text Search

Re: FULLTEXT Search performance
Posted by: James Day
Date: December 21, 2004 11:27AM

alter table papers add index id2 (id);

explain select count(p2.id) from papers, papers as p2 where match(title,keywords) against("test") and p2.id=papers.id;

And see how it compares to the previous result. Add title to the new index if your real query wants the title and you'll end up with a covering index.

No warranty and maybe one of the MySQL employees who reads this will have an alternative and/or better idea.

Options: ReplyQuote


Subject
Views
Written By
Posted
11670
December 18, 2004 08:18AM
6295
December 18, 2004 11:18AM
4656
December 21, 2004 08:40AM
Re: FULLTEXT Search performance
4691
December 21, 2004 11:27AM
4426
December 22, 2004 02:02AM
6128
December 22, 2004 07:54AM
4164
December 31, 2004 08:09PM
4055
April 15, 2005 08:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.