Kovah, Apparently, #MySQL quickly becomes slower once you reach a dozen of million records and search through them. Even with indexes.
So I looked into #Clickhouse. The same query on the same dataset only takes about 1/10 of the time. Impressive! 😯Next week @cloudhiker will get a serious speed boost!