Thanks for the note, Sergei. I admit to being confused by the documentation on boolean search. In particular, exactly what the problem domain for the two algorithms is supposed to be (and how relevancy is computed with boolean search). I don't understand why boolean search has (it seems) a totally different approach to relevancy.
Or to ask it a different way, which applications would use non-boolean search, and why? Also my understanding from the documentation and release notes is that boolean search is only available in 4.0.1, which is not yet available. Is this correct? Thanks, Bob > Hi! > > On Dec 15, Bob Sidebotham wrote: > > MySQL full text indexing looks attractive, but I'm puzzled as to how to > > use it > > for my application. > > > > I'm storing documents that I'd like to be full-text indexed, but each > > document can have multiple revisions. I'm currently storing each > > revision in full. The fulltext relevance criteria don't work well with > > this: if a document has many revisions, then all the words in that > > document become (artificially) less relevant. > > > > Perhaps the boolean search facilities will overcome this difficulty in > > 4.0.1, I'm unclear on that. > > > > Can anyone suggest ways around this? > > Either recompile mysqld with modified myisam/ftdefs.h > (using simplified weighting scheme), > or - better - use boolean search, because in your application > you perform boolean queries anyway. > > Regards, > Sergei > > -- > MySQL Development Team > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php