Efficiently computing locations from IP addresses

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

by charzom • 19 years ago

5 1 19 years ago

tlrobinson• 19 years ago

Interesting.

I find it amusing that he went to all the trouble (well, not that much trouble) of using MySQL's spatial database features when the following simple query performed even better:

    SELECT country_code
    FROM ip_country
    WHERE ip_to >= INET_ATON('%s')
    ORDER BY ip_to ASC
    LIMIT 1

Efficiently computing locations from IP addresses

Related Stories