SQL Database connection, external IP vs localhost?

Question

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?

sehrope · Accepted Answer · 2013-04-29 05:34:24Z

3

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).

answered Apr 29, 2013 at 5:34

sehrope

1,77713 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

kazinix Over a year ago

So the "thing" is aware that the external IP is its own so it won't leave the computer?

kazinix Over a year ago

I wonder what layer is the external IP determined to be locahost, OS?

sehrope Over a year ago

Yes. Network stacks are not supposed to send packets out onto external interfaces if they're meant to be consumed locally.

Collectives™ on Stack Overflow

SQL Database connection, external IP vs localhost?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related