I'm going through old emails I hadn't read, sorry it's taken so long to respond.
> All of my CF development has used data sources that have been > on the same local network as the CF Server. In an upcoming project, > I'll be connecting to a SQL server from CF by it's IP address via > VPN over the Internet. > > I'm curious to hear from others who have done this if there have > been any issues with dropped connections, poor performance or other > difficulties from within CF. This can certainly cause poor performance. First, remote connections are typically much slower than connections across the LAN. Much, much slower. This might not be an issue for you, depending on the amount of traffic you have, the amount of caching you can do, etc, but I can certainly say that I've seen cases where this has been a performance killer. Second, the VPN will probably impose some overhead as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
