3 ms·
Efficiently computing locations from IP addresses
- tlrobinson 19y agoInteresting. 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