[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: really slow queries

Subject: Re: really slow queries
From: Daniel Tiefnig <daniel.tiefnig@infonova.at>
Date: Thu, 23 Nov 2000 15:06:03 +0100
Cc: openldap-software@OpenLDAP.org
References: <NMEIJMCFCECINGDHLNMOKEIKEAAA.adepette@krameria.net>

Andy De Petter wrote:

>
> We started doing some other tests, and it seems that one simple query
> (searchfilter like '(sn=mysn)') takes upto 15 seconds !!!!
>
> Have we overlooked something, or is this normal behaviour?

maybe this is caused by the referrals... slapd searches the whole db for an
objectclass=referral, this lasts very long, if you don't obtain an index on
objectclass...
so add an 'index objectclass eq' line to your slapd.conf, or 'disable' the
referrals with the option -M of ldapsearch
u can also disable referrals in the source code, (that's what we did) if u
don't plan to use them at all...

regards
daniel
--
Daniel Tiefnig
Servertechnology
INFONOVA IT GmbH

References:
- really slow queries
  - From: "Andy De Petter" <adepette@krameria.net>

Prev by Date: openldap sample files
Next by Date: Re: Schema question
Index(es):
- Chronological
- Thread