Michael, any thoughts on how (or if) you might be able to provide both the old, simple substring searching and still make FTS available to users?
Thoughts, yes. I'll have to verify this, though. But I think if you start your search by entering a quote, then the resulting query should get very close to the simple substring search. Could you please test this?
As Phil and myself discussed, the simple search is still the preferred way to get to something without a lot of extraneous search results.
Phil's comments were based on a buggy version of the search. Unfortunately he didn't verify his search after I fixed the sorting. I'm still convinced that if the weighting of the results is done correctly, then the results of the fts should be as good as the simple text search. The additional results added to the tail shouldn't hurt. Who cares about the millions of hits google shows up for any random search? Most users will check the first one or two pages and ignore the long tail.
But FTS may still be handy for finding more obscure things, such as finding a note in a comment, or words from lyrics.
Doesn't the Advanced Search cover the obscure use case? -- Michael _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta