Full Text Indexing

[Sheila Singh]

I am considering using the full-text indexing feature with my database so that I can make use of the relevance rating provided thru MySql.

I have a database table that will grow with time as users input data.
This table will require a full-text index on each of its ten field. Will this adversely affect the performance of my database?

Also I would like to remove the 50% threshold for natural language searches. I think it may eliminate some query matches which I would want to keep.
I have not been able to find the file which has the parameter that needs to be changed. It is called `myisam/ftdefs.h'. There is no such file on my system at all. I did verify that the 50% threshold is working by querying the db for a keyword which does show up in more than 50% of the rows. Do you know how I can disable this feature? And does disabling this feature somehow impact performance of the queries?

I am running mysql version 4.1.3b-beta.

Thanks,
Sheila