While I cannot speak to the design choices made here, I can say that, in general, you are better off having a single table on which to perform a full text search as opposed to a larger group of tables in most situations. I would assume in this situation that the overhead of 110 queries would cause poorer performance than a single table search. The full text works better when it can eliminate duplicate words by having a larger data set.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
As for the Soundex function, such a performance is intended for finding words by sound when the spelling of a word cannot be relied upon. This make it useful for things such as name searching where the user may not spell the name correctly. It may be of limited use depending on context.
Dig Deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.