I have a database in mySQL that is created and maintained with a form tool called Formidable Pro, a Wordpress plugin. Currently the database has about 1000 records and will likely grow to 20,000 or more. The form tools search function is slow.
Each record has about 25 fields but we may add more.
So I need:
to enhance search performance
Skills: html, mysql administration, php