Rudder

Ah, we used to not indexes them because of the cache strategy used before we switched to mdb. It mostly does not make sense anymore, quite the opposite.

It would make sense to try to index them again by adding in slapd.conf, for database mdb, starting with the following indexes:

# Indices to maintain
index    objectClass    eq
index    isEnabled,isDynamic,isModified,isSystem eq
index    uuid eq
index    container,software eq

# Software search
index   cn,softwareVersion  eq

And if it still not make sense to use indexes, we will need to make the same patch on mdb (in #7667) than we did on bdb.

After some tests, it seems that indexes don't bring any gain:

Cycling between several request some hundreds times gave:

Without index:

real    2m39.565s
user    0m22.688s
sys    0m16.208s

With indexes:

real 2m0.766s
user 0m22.554s
sys 0m16.454s

So that's saying that OpenLDAP cache is working ok, and that we still don't really need indexes given our usage. (the real diff is certainly due to the logs not written in the log file).

So, we have to patch mdb like we did bdb.