LazyPower is a user on mstdn.io. You can follow them or interact with them if you have an account anywhere in the fediverse.
If you don't, you can sign up here.
"Who cares. I can use mysql fulltext searches and be done with it, it's not gonna be such a big deal"
One million DB records later...
"Okay, time to learn Sphinx."
@lazypower LOL
I came across this issue a few days ago - queries became unbearably slow (~25s) and I knew that making a better solution was in order.
I'm not quite keen on using ES, seeing as it seems to be exaggerated for the kind of thing I'm doing. But I'll see how Sphinx plays along :)