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