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
