With mysql 5.7, range searches on indexes (BETWEEN() or equivalent) are notoriou...

		IdontRememberIt on Nov 11, 2021 \| parent \| context \| favorite \| on: Efficient Distance Querying in MySQL With mysql 5.7, range searches on indexes (BETWEEN() or equivalent) are notoriously slow with large datasets. We discovered that spacial index (flatten to 1 dimension) can be used to solve a common issue: ip range queries. The query costs dropped and all the query metrics improved.

Does it improve in newer versions of MySQL?

I'll need to so similar work soon.