I'm making a website using Symfony 2 and Mysql as DBMS. Now, the site involves some entities that can be searchable from the home page and the searches can be by term and by location, not the two at the same time. The thing is that I installed elasticsearch on my server to index the searchable entities.
Now, does anyone knows the performance advantages of searching between a mysql search and and elasticsearch search?
Consider that on the mysql database all searchable fields are indexed using a FULL TEXT index and on the elasticsearch index all fields are indexed to be able to search on them.
Is my tests elasticsearch queries can be more de 6x faster than sql queries with mysql and Doctrine. But for security questions I have always all the information backup in mysql. As far as I've read this is a common practice. After almost a year making queries in elasticsearch I fill more confortable to make complex queries and find better results with free text inputs.