I use a proxy server to give my non-public-addressed app/db/etc. servers access to the outside world.
Something like Squid is actually designed to keep a cache and whatnot... :Den -- have offices all over the place and I avoid work everywhere. I don't like to write - I like to be finished. Richard Price On Thu, Dec 16, 2010 at 1:32 PM, Jason King wrote: > They actually say that. If you don't have a key, they only let you hit the > list a few times per hour. Then they go on to say that they only update the > list every hour, so it's essentially pointless to keep hitting the list when > you could simply download it, get better performance, save them money and > bandwidth, etc. > Since my db server is sandboxed and isolated from the Internet, I guess I > would have to use a server with web access, maybe even the webserver itself, > to fetch the file, open it, and import it into the DB. If it's just a > straight insert via XML to SQL server, and there isn't much logic involved > other than the structured import, would it be wise to just have the > webserver do it? Or could that potentially cause a big hit and lock the > server down until the import is done? I could actually setup a VM that does > nothing but fetch that file, parse it, and then insert it into the DB. My > webserver is windows, but I could just use centOS and php to do the insert > if that's all it would be doing. My app is written in cfml, but a dedicated > vm would be separate. > -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
