[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Research time is important
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
- Prev by Date:
Re:
- Next by Date:
AW:
- Index(es):