View Single Post
Old 02-23-2009, 05:39 PM   #6 (permalink)
aZooZa
 
aZooZa's Avatar
 
Name: Dale Hubbard
Last Online: Yesterday 04:07 PM
iTrader: (45)
Join Date: Jan 2003
Posts: 5,876
DNF$: 5,873
Location: Exeter, UK
Country:

Send a message via MSN to aZooZa Send a message via Skype™ to aZooZa

Ken, you might find that MySQL is too resource hungry for this particular application. Did you consider stripping out all the duplicate NS data from the zone? You can use awk and grep with flat files and that takes minutes instead of 12 -15 hours. If you look at the zone file structure, you can see the distinct points in each line (A, NS) where awk and grep will work to separate out the individual domains. I wrote a bash script that does the main donkey work if you'd like me to dig it out.

Anyway, just a thought. I have to say it's a very well presented site indeed!
__________________
UK Drop Catching Services: Dropsystem.co.uk
New! Canada TBR Drop Catching: Dropping.ca
New! QUALITY MiniSites: NOTsoMINI.com
aZooZa is offline   Reply With Quote