[thelist] Very Large MySQL Table

[Phil Turmel]

Hi Fred,

Fred Jones wrote:
> 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.
> 
>> They don't use relational databases - relational databases are relatively
>> slow in the "database" world.

Have you considered using other tools?

May I suggest grep?

First, take the zone file and strip off all but the domain name, like so:

cut -d\  -f1 <zone.txt >domains.txt

(note the two spaces after the "d\")

Then you can grep for patterns to your heart's content:

grep copperhydride <domains.txt


I'm betting both the size of domains.txt and the grep time are better
than any database solution by at least an order of magnitude.

HTH,

Phil