Re: MySQL v4 FTS speed

[Mike Wexler <mwexler@xxxxxxxx>]

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 <mysql-thread92415@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php