[imported_silkroad]

Originally Posted by Dismounted

You can't override the server-level configuration for MySQL Fulltext Searching...

It is not difficult to change the server level configuration, for example see:

11.8. Full-Text Search Functions

--------------- Added [DATE]1248094897[/DATE] at [TIME]1248094897[/TIME] ---------------

Actually, this is a better example reference:

11.8.6. Fine-Tuning MySQL Full-Text Search

The minimum and maximum lengths of words to be indexed are defined by the ft_min_word_len and ft_max_word_len system variables. (See Section 5.1.3, “Server System Variables”.) The default minimum value is four characters; the default maximum is version dependent. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then you must restart the server and rebuild your FULLTEXT indexes. Note particularly the remarks regarding

Pretty easy, don't you agree?

--------------- Added [DATE]1248095090[/DATE] at [TIME]1248095090[/TIME] ---------------

I would venture to say that the entire change to the MySQL conf takes 15 seconds and the vB options config takes 15 seconds.

There will be a little more time for MySQL to rebuild the index after restart :-)