IP or DNS in connection string - not critical

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default IP or DNS in connection string - not critical

    Hi,

    My provider has provided me with an IP address and a DNS name to the SQL
    server I use. Whilst both obviously work does anyone know if there is any
    performance increase in using the IP address to avoid DN resolution?

    I imagine any performance will be negligible.

    Andy Guest

  2. Similar Questions and Discussions

    1. Critical Connection Key Help
      We've been using Contribute in our school district for over five years. Yesterday, out of the blue, we started getting reports from users about a...
    2. need help with connection string
      i keep reading that it is not secure to hard code the connection string to the server into my swf. so how can i get the string into my swf without...
    3. connection string
      Hi there, I have recently changed the connection string on a site that was working perfectly. I used an OLE DB connection with this code: var...
    4. DB Connection String
      Hi, I need to store the database connection string inside web.config file. What would be the best way to encrypt and decrypt it? Thanks, Ali
    5. Oracle DSN Less Connection String
      Greetings.... Okay so far Dreamweaver MX connection to Oracle has left an awful bitter taste in my mouth.... I am trying a DSN Less Oracle...
  3. #2

    Default Re: IP or DNS in connection string - not critical

    If the DNS servers are under a DDoS attack you will notice it stop
    working while the IP address will work so long as it doesn't change.

    This means they both have advantages. DNS for changing the IP without
    recoding & IP address for less susceptibility to DDoS attacks.

    Andy wrote:
    > Hi,
    >
    > My provider has provided me with an IP address and a DNS name to the SQL
    > server I use. Whilst both obviously work does anyone know if there is any
    > performance increase in using the IP address to avoid DN resolution?
    >
    > I imagine any performance will be negligible.
    >
    joker Guest

  4. #3

    Default Re: IP or DNS in connection string - not critical

    That is unless there are other things which I didn't think about.

    joker wrote:
    > If the DNS servers are under a DDoS attack you will notice it stop
    > working while the IP address will work so long as it doesn't change.
    >
    > This means they both have advantages. DNS for changing the IP without
    > recoding & IP address for less susceptibility to DDoS attacks.
    >
    > Andy wrote:
    >
    >> Hi,
    >>
    >> My provider has provided me with an IP address and a DNS name to the SQL
    >> server I use. Whilst both obviously work does anyone know if there is
    >> any
    >> performance increase in using the IP address to avoid DN resolution?
    >>
    >> I imagine any performance will be negligible.
    >>
    >
    joker Guest

  5. #4

    Default Re: IP or DNS in connection string - not critical

    Good point though.

    "joker" <no-spam@netzero.com> wrote in message
    news:uuF2i48bEHA.2816@TK2MSFTNGP11.phx.gbl...
    > That is unless there are other things which I didn't think about.
    >
    > joker wrote:
    > > If the DNS servers are under a DDoS attack you will notice it stop
    > > working while the IP address will work so long as it doesn't change.
    > >
    > > This means they both have advantages. DNS for changing the IP without
    > > recoding & IP address for less susceptibility to DDoS attacks.
    > >
    > > Andy wrote:
    > >
    > >> Hi,
    > >>
    > >> My provider has provided me with an IP address and a DNS name to the
    SQL
    > >> server I use. Whilst both obviously work does anyone know if there is
    > >> any
    > >> performance increase in using the IP address to avoid DN resolution?
    > >>
    > >> I imagine any performance will be negligible.
    > >>
    > >
    >
    Andy Guest

  6. #5

    Default Re: IP or DNS in connection string - not critical

    On Thu, 22 Jul 2004 07:37:18 GMT, "Andy" <Please reply to the group>
    wrote:
    >Hi,
    >
    >My provider has provided me with an IP address and a DNS name to the SQL
    >server I use. Whilst both obviously work does anyone know if there is any
    >performance increase in using the IP address to avoid DN resolution?
    >
    >I imagine any performance will be negligible.
    Especially since the DNS info gets cached anyway. Normally, use the
    DNS name (FQDN) because your provider may change the IP address in the
    future.

    Jeff
    Jeff Cochran Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139