Regression: ldb performance with indexes

[Andrew Bartlett]

On Thu, 2024-02-29 at 22:31 +0100, Andreas Schneider wrote:
> On Thursday, 29 February 2024 21:19:52 CET Andrew Bartlett via samba-
> technical wrote:
> > On Thu, 2024-02-29 at 16:36 +0100, Andreas Schneider via samba-
> > technical wrote:
> > > Hi,my colleagues discovered a performance issue in libldb:
> > > https://bugzilla.samba.org/show_bug.cgi?id=15590
> > > 
> > > As soon as you use indexes, ldbadd will be magnitudes slower than
> > > itwas before.Could some ldb expert please look into it?
> > 
> > Your subject says a regression.  What version is this a
> > regressionagainst?
> 
> Isn't that obvious from the bug report?
> Here is the short summary:
> $ bash repro.sh 20000 indexesAdded 2 records successfullyAdded 20000
> records successfully
> On Samba 4.10: 0m01.231sOn Samba 4.19: 1m30.924s (that's 90 times
> slower)
> 
> > The very nature of a DB index is that it will take time to
> > create,possibly a lot of time, but should make reads faster.
> 
> Either the DB index doesn't work at all in Samba 4.10 or there is a
> huge performance problem in Samba 4.19. What is it?

Thanks, that wasn't written as obviously on the bug, thanks for the
clarification. 
I will follow up on the bug. 
Andrew Bartlett

-- 
Andrew Bartlett (he/him)       https://samba.org/~abartlet/
Samba Team Member (since 2001) https://samba.org
Samba Team Lead                https://catalyst.net.nz/services/samba
Catalyst.Net Ltd


Proudly developing Samba for Catalyst.Net Ltd - a Catalyst IT group
company

Samba Development and Support: https://catalyst.net.nz/services/samba

Catalyst IT - Expert Open Source Solutions