NYCPHP Meetup

[nycphp-talk] Tuning MySQL Full Text Search

Ben Sgro (ProjectSkyLine) ben at projectskyline.com
Wed Aug 22 13:35:33 EDT 2007


Hello Rob,

What I meant is that, something that has the search criteria in the title,
doesn't have more weight than something that does not, and therefor
is possibly showing up lower then another item, when I believe its
more relevant and should be displayed higher.

I'll try to rebuild the index. In order to do so, do I just run the command 
that I did to build the
original index, or is there a special syntax/command to do so?

> Also... boolean searches do have an operator (< or >) to increase or 
> decrease a word's weight:
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Cool. I'll look into that.

Thank,

- Ben

Ben Sgro, Chief Engineer
ProjectSkyLine - Defining New Horizons

Our company: www.projectskyline.com
Our products: www.project-contact.com

This e-mail is confidential information intended only for the use of the 
individual to whom it is addressed.
----- Original Message ----- 
From: "Rob Marscher" <rmarscher at beaffinitive.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Wednesday, August 22, 2007 1:12 PM
Subject: Re: [nycphp-talk] Tuning MySQL Full Text Search


>
> On Aug 22, 2007, at 12:42 PM, Ben Sgro ((ProjectSkyLine)) wrote:
>> Hello Rob,
>> I'm happy w/the relevance, but the order isn't right
> What do you mean by that?  I thought you were sorting by relevance?
>
>> too many results are being returned (which is my own issue to fix).
> Can you just apply a limit to the query?
>
>> Without the BOOLEAN, the results were really off, minimal results  and 
>> not that accurate.
> Maybe this is because boolean searches don't use the 50% threshold: ""
>
>> There is also the problem where common words, aren't returning  anything, 
>> such as a search for
>> "water". It should however, since the water keyword is very  frequent 
>> throughout the site.
> Weird... that would be in line with the 50% threshold... but you're  using 
> boolean, so it shouldn't apply.  Maybe try rebuilding the index?
>

>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php 




More information about the talk mailing list