> Keep in mind that a major limitation of the mysql > fulltext engine is that it can't index more than 500 > characters which could be a major drawback for your > parametric data.
Just some genral qiuestions, Does that mean the max. string that can be indexed and therefore searched on is 500 chars? What exactly is this limitation? > > The following assumes you will stick with mysql > fulltext indexes... > > In order to index 3 letter words, you will need to set > min_ft_word_len in your mysql.cnf file. You probably > also want to create your own list of stopwords and use > ft_stopword_file. Can I just add words or append words to the existing default stopword file? After I add words do I have to reindex the fields or restart anything? (I'm using win32) If I insert/add a record to a "fulltext table" do I have to redo(reindex) anything? Assuming I'm using a recent ver. of MYSQL. Thanks, just genral questions...thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]