Ulrich Windl wrote:
Michael Ströder michael@stroeder.com schrieb am 06.07.2017 um 14:29 in
Nachricht 55cd37d3-e407-877e-01be-096f9f7aacae@stroeder.com:
Ulrich Windl wrote:
Should I really add an index for modifyTimestamp? I got "slapd[4021]: <= bdb_inequality_candidates: (modifyTimestamp) not indexed!" (No discussions
on using
BDB, please!)
The pure log message does not say much. It depends on the real filters used
whether you should index an attribute or not. Hint: You can make *search* performance worse with more indexes.
Actually the accesslog database wanted that index, while no queries (not that I knew) were made on the accesslog database. So any access to it would be some change operation in the main database (that's how accesslog is configures: only log changes). So I don't know the filter.
You own the logs => you're the only one who can find out.
Ciao, Michael.