Re: Full-text searches sucks?

Hey! Thanks for replying. > FULLTEXT searches are great; > it's your testing of them that is poor. Kind of true, but I would have still been happy if it had found some records rather than 0 results. >Also, FULLTEXT searches are > > improved as the number of __different__ records increase. Yep, I understood that from reading the docs. > 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. I dont want to do that as its only mysql 4.1+ compatable, I presently DO have a 4.1 setup....but if we shift hosts...i dont want it to "break" my code. Thanks, Ryan On 3/21/2005 8:03:39 PM, larryullman@dmcinsights.com wrote: > > 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 > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005