query sql or dns?

[Anthony]

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

 

[Steven Burn]

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!