Hi!
On Nov 27, Mike Wexler wrote:
> >>
> >>Lets also assume that there are 1,000,000 records with the word "really"
> >>, 1,000,000 records with the word "nice" and 500,000 records with the
> >>word "toy". Lets say there are only 500 records with all three words.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >
> > SELECT * FROM table
> > WHERE MATCH (description) AGAINST ("+A +really +nice +toy" IN BOOLEAN MODE)
> > ORDER BY MATCH (description) AGAINST ("+A +really +nice +toy" IN BOOLEAN MODE)
> > LIMIT 10
> >
> > will abort the search when it retrieves the 500th document with all the
> > three words. It's impossible to say, how many index entries it will look
> > at.
>
> Where does the number 500 come from? Did you mean 10?
Didn't you say "there are only 500 records with all three words"
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
