Honestly I am not sure how it would scale, it has worked well in my
use with several thousand very large documents (a couple million rows
in the index table). You certainly couldn't use this to develop an
internet search engine...
I had never heard of MySQL not using keys in an OR type of query, but
the type of searches I have made available always used AND anyway (as
an OR query on more than a couple words is likely to return a hell of
a lot of results... e.g. every OR condition only serves to widen your
search results, not narrow them - which is generally not what people
want to do when searching documents).
Regards,
Jamie Treworgy
mailto:[EMAIL PROTECTED]
At Tuesday, May 15, 2001 on 9:29:24 AM, you wrote:
> What kind of speed can you expect to get from this after tbl_doc_index fills
> up with tens of millions of rows? Is this scheme suitable for that magnitude
> of data?
> Also, if you wish to generate a query that generates all documents that
> contain token x or token y, would mysql neglect to use the keys? I remember
> reading that field1=x OR field2=x wont use the index because a general way
> of optimizing that query hasnt been found. Correct me if im wrong. AND
> queries on the other hand should work well.
> thanks,
> ryan
---------------------------------------------------------------------
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
