is using Hosts for resolving a sql-server more performant?
Posted
by Ice
on Super User
See other posts from Super User
or by Ice
Published on 2010-03-17T09:39:40Z
Indexed on
2010/03/17
9:41 UTC
Read the original article
Hit count: 179
Hi,
we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections.
Now we consider to use a virtual sql-servername for these odbc connections and resolve it in the local hosts-file with the ip-address of the real sql-server.
Like this we can easy switch between a test-sql-database server and the the server for production in changing one single entry in the hosts.
EVERYTHING works fine and now comes the question:
Could it be that this is more performant because there is one single point on resolving the sql-server (name or ip-address)? Is there something like a network-cache / DNS-Cache?
peace
Ice
© Super User or respective owner