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