CODEWITHSUNDEEP
sql-servernetwork-programmingconnection-string
kazinix
kazinix

Reputation: 30123

SQL Database connection, external IP vs localhost?

I have an SQL database and an ASP.NET website on the same machine. My question is, what is the difference between connection string that points to external IP (of the same machine) and connection string that points to localhost? Is one of them faster than the other?

Upvotes: 2

Views: 895

Answers (1)

sehrope
sehrope

Reputation: 1777

Network traffic will not be different (neither will leave your computer) but using the localhost address is better because then you can have the DB server listen only on localhost (vs listening on the network address).

Upvotes: 3

Related Questions