Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    May 2005
    Posts
    5
    Member #
    9901
    I have a problem using mysql fulltext search for some common word that would probably get returned from more than 50% rows.
    I was reading something about that rule of 50% but I didn't find way to resolve it.
    Could anyone , please, help me about it? :classic:

  2.  

  3. #2
    Senior Member rosland's Avatar
    Join Date
    Jul 2003
    Location
    Norway
    Posts
    1,944
    Member #
    2096
    From the manual:
    The 50% threshold for natural language searches is determined by the particular weighting scheme chosen. To disable it, look for the following line in myisam/ftdefs.h:

    #define GWS_IN_USE GWS_PROB

    Change the line to this:

    #define GWS_IN_USE GWS_FREQ

    Then recompile MySQL. There is no need to rebuild the indexes in this case. Note: By doing this you severely decrease MySQL's ability to provide adequate relevance values for the MATCH() function. If you really need to search for such common words, it would be better to search using IN
    BOOLEAN MODE instead, which does not observe the 50% threshold.
    S. Rosland

  4. #3
    Junior Member
    Join Date
    May 2005
    Posts
    5
    Member #
    9901
    OK, thanks.
    My trouble is that server doesn't suppert BOOLEAN mode :classic:


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 08:48 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com