Re: Useful Relevance with FullText Boolean Mode - help
Hi! On Mar 02, Thomas Spahni wrote: > 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. Tnanks, good idea. (I'll see how it could be done) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Useful Relevance with FullText Boolean Mode - help
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Useful Relevance with FullText Boolean Mode - help
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 -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Useful Relevance with FullText Boolean Mode - help
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? I'm thinking of just counting the keyword occurences in records with a PHP script somehow and using that to order the records. Or doing a non-boolean fulltext search w/relevance first and then melding that in somehow with a boolean search. See my results below...my "peeps" are asking me for relevance/ranking - what do I do? Thanks. mysql> SELECT `page`.`title` , MATCH ( `title` , `descrip` ) AGAINST ( 'nasdac' IN BOOLEAN MODE ) AS Relevance FROM `page` WHERE MATCH ( `title` , `descrip` ) AGAINST ( 'nasdac' IN BOOLEAN MODE )HAVING Relevance > 0.2 ORDER BY Relevance DESC; ++---+ | title | Relevance | ++---+ | Code 30 Specifications | 1 | | Center for Aero Information (CAI) | 1 | | nasdac Centers | 1 | | nasdac Electronic Parts & Packaging Program| 1 | | Report/Document Number Series | 1 | | misskermit | 1 | | COSMIC | 1 | | Consolidated Operations Contract (COC) | 1 | | Directives | 1 | | Directory of Project Libraries | 1 | | nasdac Technical Standards Program | 1 | | Outstocking Handbook | 1 | | nasdac Database (NAD) | 1 | | nasdac test| 1 | ++---+ 14 rows in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
