« A Tour of the MySQL Source Code | Main | MySQL Development Model »
April 20, 2005
Using and Extending Full Text in MySQL
Listening to Joe Stump talk about MySQL's full text indexing at MySQL 2005. Joe is at eNotes.com.
I looked at the full text search a year or so ago but it didn't feel like it was worth the switch from DBIx::FullTextSearch. The matching of MySQL's FULLTEXT didn't quite do the job, and weighting is important to us.
It appears that not much has changed in FULLTEXT since I last looked.
Joe has created a weighting workaround. He does multiple queries on different fields, and then takes the relevancy from each query and multiplies it by a factor based on the field that the match came from. Joe then combines the results and sorts by the calculated relevancy.
Joe indexes PDFs, Word docs and MP3s with special tools.
Posted by mike at April 20, 2005 7:54 PM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/249