What is the best way to have full text search where data in database is frequently updated I am working on an application where the database is continuously and periodically updated, and the frequency of updating of data is daily, weekly, monthly, and yearly based on their type. I want to implement full text search, I am using MySQL and applied full text indexes, and the search is working fine, but the job working for addition/updating of data was adversely impacted.

Does anyone have a solution that can be implemented for full text search for a continuously updated dataset?
I presume that update frequency in the worst case, would be a day, in your case. You could try Sphinx for this, as it is really fast and works well with MySql. And you could think of ElasticSearch also if the data is huge.

https://stackoverflow.com/questions/2271600/elasticsearch-sphinx-lucene-solr-xapian-which-fits-for-which-usage