Re: Research time is important (2)

["Markus Storm" <Markus.Storm@mediaWays.net>]

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