>>> Michael Ströder <[email protected]> schrieb am 17.08.2019 um 20:37 in Nachricht <[email protected]>: > 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.
