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 di

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.