hi
there is a past topic like this but i want to know what is the solution after 4 years
now i use mysql and i have like 6000000 row per table and high request per second and i use slim framework to build my app
because of lots of queries and request my app goes slow
what is your suggestion?
I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/
Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.
Have also a look at this "live coding" recording.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.