[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Research time is important (2)
Turn on debugging and watch for log lines telling you how many
entries match each part of a filter. Maybe you are bitten by
allidsthreshold, causing all entries to be examined.
Or you might have a broken index. Try regenerating it.
And upgrade to 2.0.7, anyway :)
Markus
Benoit.Le_Bras@alcatel.fr wrote:
>
> 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=10)(VoiceMailboxId=11)(VoiceMailboxId=12))(VPUNumber=2)(vpuSiteName=clust50))"
>
> the result research take 4 minutes (timelimit) in one case :
>
> - if the vpuSiteName exist, VPUNumber don't exist and whatever the existence of the VoiceMailboxId
>
> For the other case the result research take 1 sec
>
> 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
begin:vcard
n:Storm;Markus
tel;fax:++49 +5241 80-67867
tel;work:++49 +5241 80-7867
x-mozilla-html:FALSE
org:mediaWays GmbH;NMW-T
adr:;;Postfach 185;Guetersloh;;33311;Germany
version:2.1
email;internet:Markus.Storm@mediaWays.net
x-mozilla-cpt:ils.mediaways.net;23744
fn:Markus Storm
end:vcard