--On Friday, June 28, 2024 7:30 AM -0700 Quanah Gibson-Mount quanah@fast-mail.org wrote:
--On Friday, June 28, 2024 7:41 AM +0000 "Windl, Ulrich" u.windl@ukr.de wrote:
[Windl, Ulrich] That "test" only compared sizes directly after loading the database, but it did not compare the sizes when the databases are "in use". For example, how do they behave when you change one attribute in 50% of the entries (just for example). What happens when you do that 10 times?
Like with statistics you can tune any test to show the results you want to see. So I'm not convinced that I am "factually incorrect" yet.
I did a write test too, MDB requires substantially fewer resource in that case as well:
https://wiki.zimbra.com/wiki/OpenLDAP_MDB_vs_HDB_performance
I will say that *early on* in the development of back-mdb/lmdb there were issues with the freelist that could cause explosive growth, but those were fixed years ago.
One thing I would note - If you have a multivalued attribute that has lots of values in a given entry and changes relatively often (say large ldap groups, where something like "member" changes), then it is important to configure multival (IIRC this is not available in the 2.4 release series). I generally use 100,10.
Regards, Quanah