[thelist] Very Large MySQL Table

Chris Anderson Chris at activeide.com
Tue Feb 10 17:04:09 CST 2009

> Data is a flat text file like this:
> aaa NS
> bbb NS
> meaning that aaa has DNS pointed to etc.

FWIW if the data is in alpha order, using a binary search *by hand*
could be quicker than using a database ;-)

> > Oh, and they don't use a shared web hosting account :)
> OK, now I know their secret. ;)


Search results are also cached and the caches distributed so hitting the
primary nameserver is not always necessary.
Those DNS searches may have not had to go much further than your ISP!


More information about the thelist mailing list