> 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 where it gets normalized will help quite a bit in reducing the size of the files. For large tables, it will help immensely. > 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? I haven't really thought about it. Although I don't see any value in one-letter words (or numbers). I use min_word_len=3 and my own stop list, which is merge of stopwords in many languages. I made both changes at the same time and ended up with a slightly smaller index. --steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
