[thelist] Very Large MySQL Table

Phil Turmel pturmel-webdev at turmel.org
Tue Feb 10 19:01:20 CST 2009

Hi Fred,

Fred Jones wrote:
> Data is a flat text file like this:
> aaa NS
> bbb NS
> meaning that aaa has DNS pointed to 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.



More information about the thelist mailing list