Efficiently computing locations from IP addresses
1–2 of 2 posts
Re: Efficiently computing locations from IP addresses
#2Interesting.
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