Optimise BETWEEN queries

from the Artful MySQL Tips List

The MySQL optimiser has big problems optimising queries with BETWEEN conditions. Here are two fascinating blogs on the topic:

Juan Cole: http://jcole.us/blog/archives/2007/11/24/on-efficiently-geo-referencing-ips-with-maxmind-geoip-and-mysql-gis/

Shlomi Noach: http://code.openark.org/blog/mysql/sql-finding-a-users-countryregion-based-on-ip

Last updated 16 Aug 2024
Return to the Artful MySQL Tips page