Qmail-LDAP
[Top] [All Lists]

Re: qmail-ldap server is to "slow" - how to tune it?

To: qmail-ldap@qmail-ldap.org
Subject: Re: qmail-ldap server is to "slow" - how to tune it?
From: Claudio Jeker <jeker@n-r-g.com>
Date: Fri, 18 May 2007 14:05:11 +0200
Delivered-to: sp-com-lists@consult.net
Delivered-to: qmail-ldap-list@securepoint.com
Delivered-to: mailing list qmail-ldap@qmail-ldap.org
In-reply-to: <f5ba7b270705180323k1307378ek3c0285e5bb8c4970@mail.gmail.com>
Mail-followup-to: Claudio Jeker <jeker@n-r-g.com>, qmail-ldap@qmail-ldap.org
Mailing-list: contact qmail-ldap-help@qmail-ldap.org; run by ezmlm
References: <f5ba7b270705160255x3fbddeddkd1124757edf63c8c@mail.gmail.com> <20070516112758.GB1987@diehard.n-r-g.com> <464B0ADC.9090602@odyssey-management-services.com.au> <f5ba7b270705172231h5ded671evbe65fe4d83ea2594@mail.gmail.com> <f5ba7b270705180323k1307378ek3c0285e5bb8c4970@mail.gmail.com>
User-agent: Mutt/1.5.12-2006-07-14
On Fri, May 18, 2007 at 05:23:05PM +0700, sato x wrote:
> Guys...
> 
> I have changed the indexes and the time needed to send email reducing
> about 2 seconds. Below is the indexes for the ldap server. Is it
> correct?
> 
> # Indices to maintain
> index      objectClass  eq
> index   cn,uid                  pres,sub,eq
> index   mail,accountStatus      eq
> index   mailHost,mailMessageStore       sub,eq
> index   mailQuotaSize           eq
> index   userPassword            eq
> index   uidNumber               eq
> index   gidNumber               eq
> index   memberUid               eq
> index   givenname               eq
> index      sambaSID             eq
> index      sambaPrimaryGroupSID eq
> index      sambaDomainName      eq
> index      default              sub
> 

I use the following indexes for qmail-ldap:
index           objectclass                             eq
index           uid                                     eq,sub
index           cn,sn,mail,mailAlternateAddress         pres,eq,approx,sub


cn, sn are indexed for the frontend. Also the sub, approx and pres indexes
are mostly for the frontend. Qmail-ldap only does eq lookups. If you use
other fields in search queries you should consider to index them as well
(e.g. for qmail-group).

-- 
:wq Claudio

<Prev in Thread] Current Thread [Next in Thread>