Research time is important

[Benoit.Le_Bras@alcatel.fr]

Hi All,

I am trying to do a search on my database that contains about 400 000 entries

When i do a search like

ldapsearch ... "(&(|(VoiceMailboxId=830)(VoiceMailboxId=831)(VoiceMailboxId=832)(VoiceMailboxId=833)
(VoiceMailboxId=834))(VPUNumber=1)(vpuSiteName=clust50))" dn

and if there s no entry corresponding, the result research take 4 minutes (timelimit):

slapd[19599]: conn=0 op=164 SRCH base="ou=ansf, o=alcatel, c=fr" scope=2 filter="(&(|(VoiceMailboxId=810)(VoiceMailboxId=811)(VoiceMailboxId=812)(VoiceMailboxId=813)(VoiceMailboxId=814))(VPUNumber=1)(vpuSiteName=clust50))"
slapd[19599]: conn=0 op=164 SEARCH RESULT tag=101 err=0 text=

So, if there 's any entries corresponding, the result research take 1 sec:

slapd[19599]: conn=0 op=160 SRCH base="ou=ansf, o=alcatel, c=fr" scope=2 filter="(&(|(VoiceMailboxId=790)(VoiceMailboxId=791)(VoiceMailboxId=792)(VoiceMailboxId=793)(VoiceMailboxId=794))(VPUNumber=1)(vpuSiteName=clust50))"
 slapd[19599]: conn=0 op=160 SEARCH RESULT tag=101 err=0 text=




My configuration in slapd.conf :

index cn,uid,telephoneNumber eq
index telephoneNumber2,telephoneNumber1,telephoneNumber3,telephoneNumber4,adrIMAP4 eq
index vpuSiteName,VoiceMailboxId,VPUNumber eq
index objectClass eq

I use a BerkeleyDB database and openldap 2.0.4

Any information would be greatly appreciated.

Thanks in advance

Benoit