Im using an ORM - Eloquent for my db queries. I have a table with 17M records and 4 indexes in there. Everything is fine and fast. However I have 6-7 fields that are VARCHAR and needs to be searched with %LIKE%. Basically the steps are: 1.Search the 17M table by indexes and retrieve about 20k rows. 2.From that result search a single string into all record's fields and return the ones which success.
The question is what to be used for step 2 for best performance and realization. Im thinking of using sphinx or elastic search but dont know how fast its going to be.