Re: ft_min_word_len=2... YAY or NAY?

2004-09-17 Thread Egor Egorov
[EMAIL PROTECTED] wrote: I'm wondering whether or not I should implement fulltext searching for 2 letter words within a product database (HP, TV, G5, LG, etc)... My searchable text is currently about 600Mb and a 3-letter fulltext index is consuming about 420Mb. Is the trade-off for user

Re: ft_min_word_len=2... YAY or NAY?

2004-09-14 Thread Thomas Spahni
John, give it a try. I had to enable ft_min_word_len=2 on a collection of legal texts because people are searching for abbreviations consisting of 2 letters. It works fine for me. Thomas Spahni On Mon, 13 Sep 2004 [EMAIL PROTECTED] wrote: I'm wondering whether or not I should implement

ft_min_word_len=2... YAY or NAY?

2004-09-13 Thread JVanV8
I'm wondering whether or not I should implement fulltext searching for 2 letter words within a product database (HP, TV, G5, LG, etc)... My searchable text is currently about 600Mb and a 3-letter fulltext index is consuming about 420Mb. Is the trade-off for user convience vs. performance worth