Sergei Golubchik wrote:
> 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"
Yes I did. My mistake. Thanks.
>
> Regards,
> Sergei
>
>
---------------------------------------------------------------------
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