[thelist] Very Large MySQL Table

[Chris Anderson]

> Data is a flat text file like this:
> 
> aaa NS 1.2.3.4
> bbb NS 5.6.7.8
> 
> meaning that aaa has DNS pointed to 1.2.3.4 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 :)
> 
> LOL
> 
> OK, now I know their secret. ;)
> 

LOL+1

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!

Chris