ms sql server with limited bandwidth
Posted on 2014-03-04
I work in a office building that have t1 1.5 upload and download in internet connection.
And I want to develop an asp.net/c# intranet with MS SQL database 2012 for the internal office and allow website hosting in different location like goaddy.com to read/write the ms SQL Server, and I have the following worries.
1. Speed issue to load the database from the external website.
2. And with that slow speed it may even impact local office users.
And I am thinking to have co-location to host the database but I need to sync the data between two databases. and I think it is working but again speed is the issue.
Want to ask the experts we have any options in this case.