156GBs db and of 1.5 billion DNS records
Published: Wednesday, November 28, 2018 written by Drew Jackson
View Count: 199
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 an Andrew Jackson 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.
© 2020 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.