Hi!
On Sep 11, Matt W wrote:
Hi Sergei!
I'll try to keep my observations/ideas below as short and simple to
understand as possible. :-)
Thanks :)
Here I reply very quickly to some questions.
Another reply will follow...
Sure, boolean mode is faster in *some* cases, since, as you said,
direct contact with
the developers like this!
I'll try to keep my observations/ideas below as short and simple to
understand as possible. :-)
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 3:31 PM
Subject: Re: Lots of FULLTEXT stuff
Hi!
First: thanks for ideas - I'm adding them to my todo :)
About dates - it's very difficult to say when a particular feature will
be implemented. Anyway, first I'm going to finish with this 2-level
index structure - to implement optimizations that rely on it.
Any speed/optimization
Thanks for replying. Your posts that I've found when searching for
FULLTEXT information have had great ideas. :-) Searching millions of
posts efficiently and effectively isn't easy. :-( Heh.
FULLTEXT does not scale very well once the files get bigger than your
RAM.
The redesign of the index
Matt,
I fully agree that indexing short words and numbers is a necessity
sometimes. I'm processing legal text where abbreviations are widely used
and people want to search for chunks like:
Art. 234 Abs. 3 OR
and the search should also find occurrances of
Art. 234 OR
These are so
Message -
From: Steven Roussey
Sent: Sunday, August 24, 2003 3:39 PM
Subject: RE: Lots of FULLTEXT stuff (suggestions)
And the FULLTEXT index shouldn't always be chosen
for non-const join types when another index would find less rows
first.
The short answer is that it doesn't work that way
My TODO List:
1. Speed
More speed in inserts, deletes and selects.
2. Stoplist
1 stoplist for each index
create fulltext index on x( y) stoplist 'mystop'
the stoplist could be divided in section like my.cfg:
[STOPWORD]
[VARIABLES]
ft_min_word_len=3
[CLASSES]
...
[SPECIAL CHARS]
...
The
Hi all,
I'm planning to use MySQL's full-text search for my forum system
(possibly 5+ million posts). I've been playing with it a lot lately to
see the performance and functionality and have some
suggestions/questions.
First, since a few of you may be wanting to know, here is a thread where
I
Lots of stuff
STEMMING! (controlled more finely than server level I hope),
multi-byte
character set support, proximity operators. Anything to get it closer
to
Verity's full-text functionality. ;-)
Yes, all these things would be nice... :)
And the FULLTEXT index shouldn't always be chosen
