Re: query sql or dns?

From: Steven Burn (pvt_at_noyb.com)
Date: 09/20/04


Date: Mon, 20 Sep 2004 03:53:41 +0100

I'm no expert but, I'd probably say, query the SQL table...... (Aaron will
be able to tell you which is best)

--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Anthony" <antgoodlife@nospam.comcast.net> wrote in message
news:OUsI6RonEHA.3680@TK2MSFTNGP10.phx.gbl...
> I have a .asp that returns all (thousands) of ip addresses logged by one
of
> our routers.. Most of them are internal IP Addresses some however are
> external.
>
> I also dump all of our (internal) dns entries daily in to a sql database.
>
> The .asp lists all the ip addresses as a 'link' to a javascript popup
window
> called NSLOOKUP.ASP.. (which in turn uses QDNS.DLL) to dsiplay the host
> name.
>
> I want to list the hostnames in a seperate column instead (Which will save
> clicking time).... my question is this :
>
> Should I query our dns server for the hundreds of dns entries each time
the
> page is loaded, or would it be smarter to just query the sql table that
> stores them... (Of course displaying EXTERNAL or something if the dns
isn't
> resolved via our Internal DNS Databases)..
>
>


Relevant Pages

  • query sql or dns?
    ... I also dump all of our dns entries daily in to a sql database. ... The .asp lists all the ip addresses as a 'link' to a javascript popup window ... Should I query our dns server for the hundreds of dns entries each time the ...
    (microsoft.public.inetserver.asp.general)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)