Re: scaling...

[Simon Murcott <simonmu@optimation.co.nz>]

On Wed, 18 Aug 1999, Carl Moberg wrote:

   
    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 ?
   
If any of your clients using this are MS Outlook clients index:
  cn
  sn
  givenname
  display-name
  mail

Outlook will try to match on these keys.   

Regards

Simon Murcott

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 Optimation New Zealand Limited
 Exchange Place, Willeston Street, Wellington, New Zealand
 Phone +64 4 4727218, Fax +64 4 4727219, Mobile 025 405821
 S.Murcott@optimation.co.nz
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 A closed mouth gathers no foot.