RE: 3-letter stop words in FULLTEXT

2002-01-04 Thread Dave Rolsky
On Fri, 4 Jan 2002, Chris Lott wrote: > How is full-text working for you otherwise? Is it excruciatingly slow to > generate indexes and optimize tables as some have said? Oh god, yes. Running 3.23.46 on Linux with a 1Ghz PIII and 4 GB of RAM it _still_ takes a heck of a long time to do optimize

RE: 3-letter stop words in FULLTEXT

2002-01-04 Thread Chris Lott
> Is there some way to turn off the default 4-letter > minimum length for words in the FULLTEXT index in mysql > 3.23.41-nt ? from: http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html > Minimal length of word to be indexed is > defined by MySQL variable ft_min_word_length. > Change it to th

3-letter stop words in FULLTEXT

2002-01-04 Thread Stephen Simons
Is there some way to turn off the default 4-letter minimum length for words in the FULLTEXT index in mysql 3.23.41-nt ? I am running a database of a fixed set of texts (about 150MB) of a religious nature and the 4-letter minimum length setting makes it impossible to search for "God" among other