Hosting on Remote SQLServer?

There is nothing wrong with the production server. The forum makes at least 10 calls to the database and when the database and the server are not on the same network each call to and response from the SQL server adds additional time. When trying to find the problem in the time difference, I added a timer after each SQL call and for the configuration I currently use each call added an additional second to the rendering time of the page.

The default page itself as written make one call for the categories, one call for all the forums in each of the categories, one call for per forum for moderator groups, one call per forum for moderator users, one call per forum for last post, one call per forum for the forum permissions. If you have one forum that 6 DB calls. If you have 3 categories with 3 forums each, there is 1 call for the categories, 3 calls for the forums in the categories, 9 calls for mod groups, 9 calls for the mod user, 9 calls for the persmissions for a total of 31 calls to the database.

Rewritten there is one call to the database which returns the categories, forums, mod group and mod user plus one call for each of the forums permissions. This reduces the 31 calls previously down to 10, thus reducing calls to the database by 1/3 and the overall speed by over 15-20 seconds. I haven't begun work on the other pages, but I'm sure that they will see similar changes and speed reductions.

Keep in mind this won't affect most people because most have the SQL Server and web server on the same network. I have my SQL server local to me (and remote to the web server) because doing so allows me to optimize the SQL Server and its databases and the net affect is usually only .2-.5 second difference in speed for data access. However that multiplied by 30 is 6-15 seconds which is what makes the difference here.