GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com

myBlog

myBlog Home

Back to Blog MTNCOMP


156GBs db and of 1.5 billion DNS records

Published: Wednesday, November 28, 2018 written by Drew Jackson
View Count: 114
Keywords: a aaaa mx cname txt dns records icann



so, doing the research of the Internet, amazing... 156GB database and 1.5 billion records
 
amazing number of records in a DNS scan.... the database of a DNS Scan revealed 1,526,763,840 records (a, aaaa, mx, cname, txt, ptr, etc).. time to narrow the scan..
 
so processing time to load 156GB 1.5 billion records of json/xml data was 6.5 hours using an i7 920 into sql 2017 (ps. sql 2014 max cap is 10gb under developer license, so you need 2017 with developer/community license. SQL dedicated full memory, 15GB DDR3 1600 RAM, SATA III 7200 RPM drives..
 
error rate of data bcp in was 5 records / rows... truncated.. no biggee.. 
 
let's see what my formulas for figuring out who is doing what provides us... correlations relate to what you might ask?
 
more to come...
 
 
 

if you found this article helpful, consider contributing $10, 20 or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2019 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.