I wasn't sure whether this was best suited to SO or SF, I originally posted this on SO - Link to original - but it seems to me now that it probably is better suited to SF. Moderators please feel free to close either if it obvious to you.
We're implementing some code on our homepage that depends on a geoip lookup for every unique vistor and we have a choice of querying a geoip web service (Maxmind) or downloading the geoip database and querying it locally. The server is currently a 512MB Linode instance and only receives around 1500 uniques per day however we are concerned what will happen when during a traffic spike. Obviously upgrading the servers memory is easily achieved if going local is the best route. Using the database locally is marginally cheaper and therefor not a factor.
- Which solution in your opinion would likely give us a faster page load speed when the server is not under load?
- Which solution is more likely to survive when the site gets hit with a flood of traffic? Assuming we have to avoid caching.