Quote:
Originally Posted by aZooZa  Ken
Sorry to be so lax - I've not sent you that script. I will do it tomorrow. |
No problem Dale - I appreciate any assistance ...no rush.
Thanks for all the positive feedback everyone. My two biggest challenges right now are:
1. Allowing you to retrieve all of the domains associated with a specific name server... I have my arms around this one but you've got to realize that if you searched on something like "NS1.SEDOPARKING.COM" you're going to be sitting there watching the clock spinning for quite some time
(around 1.3 million domains pointed to that one alone). But it will certainly be a useful tool for getting all of the domains that are associated with your own personal name servers...or other non-parking servers.
2. Allowing you to search on a substring for active domains (this already works for dropping domains because the dataset is far smaller). This one may end up being a back breaker since searching on a substring or REGEXP within 92 million records, no matter how many tables I split them up in to, is going to take a long time. What I might do is if you want to search on a substring or domains that ends in a specific string, make you type in the letter or number that the domain starts with... that will narrow down the list somewhat... but considering domains beginning with the letter S make up almost 10% of all domains, narrowing down on that letter doesn't really help all that much... I'd still be doing a substring search on a record set of over 7 million.
Check out the new pie chart that shows the breakdown of the 6.6 million parked domains..... Domain Sponsor and SEDO make up about 45% of that... I just picked the major parking name servers and grouped them... interesting stuff. I'm going to have 4 pie charts - Current, Last Month, Last 6 Months, Last Year... something like that... so that you can see the change over time.