Antw: Re: mdb index reporting available?

["Ulrich Windl" <Ulrich.Windl@rz.uni-regensburg.de>]

>>> Michael Ströder <michael@stroeder.com> schrieb am 17.08.2019 um 20:37 in
Nachricht <123c2421-b539-14cb-6c82-44235675b5cd@stroeder.com>:
> On 8/17/19 2:52 PM, Marc Roos wrote:
>> Over time I am adding indexes until there are no such messages
>> (except for some incidental queries).
> And that's exactly the wrong thing to do!
> That's why I requested to disable those messages in ITS#7796:
> 
> https://www.openldap.org/its/index.cgi?findid=7796 
> 
> By adding random indexes just to get rid of not-indexed warnings you can
> dramatically lower your search performance. You should only add an index
> if you analyzed that clients send search requests with filters which can
> make good use of the index.

I agree that some thinking before adding an index isn't a bad idea, but still
I think these messages are important as they can make you start thinking.

> 
> Learn about search candidate sets:
> https://unix.stackexchange.com/a/457561 
> 
> LDAP filters used by clients can be seen with loglevel stats.
> 
> Ciao, Michael.