We are in the process of setting up an E-Business Research service and would value your advice & expertise.
Let me start by providing you with an sight on the service that we are intending to offer. Simply we have a database hosted on MS SQL that contains 8-10 million records and is approximately 2.5GB in size. The service we offer is simply to allow registered users access to this database through our web site, by executing reports & searches. The DB is extremely dynamic.
For hosting the Web Site, we have two options…. (1) In House (2) Outsource it.
Estimated costs for "Outsourcing" are approximately US$ 400-US$ 1,200 per month. I fully agree there are tremendous benefits of hosting a web server with a third party (scalability, realiability etc..), however being a startup organisation, funds are extremely valuable. Therefore we decided not to go for this option, instead we "were" planning to host it inhouse.
However, I made the mistake in thinking that we had a connection speed of 1MB Upstream, when in fact we have 256KB. The costs of upgrading to 1MB are huge. So I have had to re-think... As said above, outsourcing it is not cost effective, so I was considering a middle of the road solution, which is the following:
1. Outsource the Host the Web Server part
2. Host in house the Database.
Therefore the our web application would execute a connection (via http) to the DB and then parse the results. The benefits of this option are that
(1) We obtain scalability, realiability etc re Web Server
(2) We are able to host the DB ourselves which is the 'expensive' part
In order to enable this solution, we were going to upgrade the 256KB Upstream to 512MB, which is manageable.
The alternative solution to the above is purchase the 512MB Upstream and use a Dual WAN Router to upgrade this further.
The question I have for you experts is: Based on the above, do you think this is the best soluion? Do you think 512MB upstream for DB info only is sufficient?
Thanks in advance for your help & support.