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,
At 03:53 PM 5/15/01 +0200, DEVOS BASTIEN wrote:
>Excuse me but what do you mean by FullText ? Is this a full-text search
>engine in MySQL ???
FULLTEXT is a kind of index in MySQL that allows for faster queries and
search-engine like "relevance" values for sorting the results.
Here's a link to s
engine in MySQL ???
>
> > -Original Message-
> > From: ryc [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 15, 2001 3:29 PM
> > To: James Treworgy; Chris Nichols
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Re[2]: MySQL FullText improvements in V4.0
>
Re: Re[2]: MySQL FullText improvements in V4.0
>
> 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 generat
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 key
You can do this yourself, pretty easily by building an index in
advance. I've been using the following technique to implement full text
searching since before it existed in MySQL in any form. Tokenize
each unique word in a document and store the word & count in tables:
tbl_tokens:
token_id int
to
I too am curious! I think one feature that I'd really like to see is the
ability to tell the number of times a string appears inside another
string. This would help a lot when trying to do search results weighting.
-Chris
On Mon, 14 May 2001, David Simmons - EliteUKServe.Net wrote:
>
> H
Hi,
I've heard that there are plans to improve the database fulltext capabilities such as
the ability to search for words less than 4
characters
in length and searches such as +word1 -word2 and that these changes are to come in
version 4.0.
Can anyone confirm this and also if so can you give
