scaling...

[Carl Moberg <carl@telia.net>]

 I'm trying to build a large tree for servicing
 my sendmail servers with external to internal
 address translation. I'm experiencing some
 (seemingly :) size-related problems. The database
 will contain 1.1M entries to start with, and will
 grow from there.

 Is there anyone running a service of this size and
 willing to share experience on a couple of things
 like;

 1. Building the 1.1M DN tree takes between
    6-8 hrs. This is on a 266P2 w 512M, using
    dbcachesize of 10000000. Any hints on how
    to speed this up ?

 2. The response times for queries right
    now is about 1 sec, I would like to
    go to 0.1 sec (from localhost). Any
    hints on indexing strategies ?

TIA,
-- carl
------------------------------------------------------
Carl Moberg, <carl@telia.net>               CM551-RIPE
Telia Network Services                       CM2-6BONE