How to work with data filtering?

Question

MySQL

Hey!
Project on php+mysql
Tell me, please, how can I optimize the search on the site?
I don't need full-text search, but (for example) sphinx and elasticsearch are only needed for this?
In general, the task is: filtering a set of tens of thousands of lines (there is no search as such) ...
Thank you!
(can upload to RAM via redis and only then filter... or via mongo)..
Give advice or maybe a link to (thoughts, tests...) about this.

Answer 1

If aggregation of data from different tables is not needed, it will be enough for you to create indexes on tables. All filtering is done using indexes.

Answer 2

Well duck and filter with the same mysql.
Indexes are designed for this :)