I inherited a database table that needs FULLTEXT search capabilities. However, the database is not designed without flaw and the said table has 66 columns with 50 columns needing a FULLTEXT search. The 50 columns represent questions in a standard survey
My question before performing an index on said 50 colums is....
a.) How poor will the performance be for FULLTEXT on 50 fields?
b.) Is there any danger of crashing MySQL with such an action (All of the fields are TEXT and sometimes hold several hundred maybe thousands of characters)?
c.) Given the time, I would redesign and implement, but is it possible to use the existing schema with this configuration? Does anyone see any other dangers (performance or otherwise)?