Re: Full-text searches sucks?

From: Date: Tue, 22 Mar 2005 04:03:39 +0000
Subject: Re: Full-text searches sucks?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-211260@lists.php.net to get a copy of this message
which means because I i getting a match for well over 50% of the records...its disregarding it.
Yes, this is exactly the problem.
Now i am in two minds if i should use this or go back to the same old dirty way...of exploding the search and using LIKE '%%' for each word
FULLTEXT searches are great; it's your testing of them that is poor. What validity is there is "searching" through X number of identical records? This isn't a real test at all. Also, FULLTEXT searches are improved as the number of __different__ records increase. If you want to see some results, regardless of the 50% threshold, use the IN BOOLEAN MODE feature. Keep in mind, though, that in your case any search will return either 0 or 700 results. Larry

« previous php.general (#211260) next »