I work for a company that wants to integrate a website with their Microsoft Workgroup SQL server 2005. The use Small Business Financials to modify the content within the database. What I’m working on is creating the website that interacts with the database. I’m trying to find the best possible solution for the site. We have a T1 line and I’m wondering which of the following I should do.
1. Host the website from the SQL server itself.
2. Use our external web host with php to connect and query from the server.
3. Use Web Synchronization to create a database on the web host and read from that.
I have it currently connecting to the server from our web host and it seems to be running slow. Any ideas?
