Re: Useful Relevance with FullText Boolean Mode - help

[Thomas Spahni]

Hi Sergei,

I have used FT search on a collection of ~ 38'000 documents totalling 550
MB of data since 4.0.2. To my observation people have a strong tendence to
search for a few words they expect to be found close together in the text.

As far as this is technically possible it would be helpful to give some
extra relevance to those hits where the 'distance' between words is small.

Best regards,
Thomas Spahni

On Tue, 1 Mar 2005, Sergei Golubchik wrote:

> Hi!
>
> On Feb 26, leegold wrote:
> > Is there any way to make relevance when using boolean mode more useful?
> > If not, are there plans in the future Fulltext development "todo" for
> > making it useful?
>
> Current relevance formula is described in internals.texi (see mysqldoc
> repository on mysql.bkbits.net).
>
> Plans - yes, if the current one is bad.
> But I don't know what to put instead.
> Feel free to suggest a better weighting scheme :)
>
> Regards,
> Sergei