Possibly moving to InnoDB

[Max Kanat-Alexander]

On Tue, 2006-08-08 at 17:59 +1000, Bradley Baetz wrote:
> >  Otherwise, we could roll our own fulltext engine or use something like
> > Senna.
> 
> I don't really think we want to go down that path. [snip]

	Yeah, I think it's probably not necessary to roll our own fulltext
engine at this time.

	The solution I'm thinking of is this:

	Make the index on bugs.short_desc a normal index. Instead of doing a
fulltext match against bugs.short_desc, do a substring match. And just
add "1.0" to the relevance for any bug that has the word in the title.
This would solve bug 347721, and it would also handle one of my biggest
pet peeves with fulltext search--that it often ranks things very low
even if they have the exact word in the summary.

	Anyhow, if you look at the code now, you'll see that we only use the
fulltext index on short_desc to determine the relevance. For the actual
searching we use a REGEXP, so my idea wouldn't really change much anyhow
(just the order results are returned in).

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.