[IdontRememberIt]

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.

[hu3]

Does it improve in newer versions of MySQL?

I'll need to so similar work soon.