My IIS7 ASP.NET website is hosted on the same Win 2008 server as my SQL 2008 R2 database.
My web applications have my SQL connection string in the web.config file. It looks like this:
Would connections speed up if I did something like DataSource = Localhost or the private-side IP, or something like that? Is what Im doing the best practice? I favor browsing speed for the end user (web visitor) above all else