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: 183

Filed under:
|
|
|

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

Related posts about hosts

Related posts about sql-server