Hi Steven, 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.
Thinking about ft_min_word_len some more (and how I wish they'd lower the default), I don't really see that much use/purpose for a minimum word length. Most 1-3 letter words that you don't want indexed should be stopwords anyway, right? So why NOT index the ones that are left? Doesn't seem like it'd make the index much larger to me. BTW, what is your min_word_len value? ----- Original 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 (also, I think this is > why there are no composite indexes between integer and fulltext > indexes). The two systems don't know anything about each other. Yeah... > > Also, are the current MySQL versions using the "2 level" full-text > > index format yet? I'm thinking not? > > No. MySQL 4.1.0 has some low-level support for this, but FTS needs to > altered (quite a bit I'd guess) to use it. So there is hope that it will > come in the 4.1.x line, but no guarantee. I'm hoping for 4.1.x! BTW, I wonder if Sergei is the [only] one who handles all the full-text coding? > > In November 2001, he said the new .frm format would be here "this > > year." It's been almost 2 years since then, so when is it do? ;-/ > > I think it was pushed back to version 5.1. I'd figure another two years. Aww. :-( Yeah, now I remember seeing that in "Features planned for 5.1." Since the acquisition of SAP DB, I think they're supposed to have more resources for faster development. Maybe some of these things will come sooner than expected. That's what I'm hoping anyway. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
