Exploring mod_geoip
Problem Statement
We have been inherently using IP Lookups for various purposes :
Redirecting a user based on country.
Advertisements and banners specific to the country/city of access.
Default landing page based on user location.
Country specific contact details.
Fetching country from IP seems a trivial task. However, to fetch a country name against a given IP we usually query the database (either spatial or range queries), which results in a large number of sql queries everyday, thus increasing the database load.
Solution
mod_geoip is an Apache extension,... Read More