Hi markus,
Thank you for your Help,
I have watch the log file and ,when the research take the timelimit, slapd compare one by one the entries to the filter
I have regenerate the index and there is the same problem.
thanks
ben
---------------------- Forwarded by Benoit LE BRAS/FR/ALCATEL on 02/02/2001 15:28 ---------------------------
"Markus Storm" <Markus.Storm@mediaWays.net> on 02/02/2001 15:28:14
To: Benoit LE BRAS/FR/ALCATEL@ALCATEL
cc: openldap-software@OpenLDAP.org
Subject: 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
Attachment:
Markus.Storm.vcf
Description: Binary data