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" <[EMAIL PROTECTED]>
To: "NYPHP Talk" <[email protected]>
Sent: Wednesday, August 22, 2007 1:12 PM
Subject: Re: [nyphp-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
_______________________________________________
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
