Regression: ldb performance with indexes

[Andreas Schneider]

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 it
> > was before.
> > Could some ldb expert please look into it?
> 
> Your subject says a regression.  What version is this a regression
> against?

Isn't that obvious from the bug report?

Here is the short summary:

$ bash repro.sh 20000 indexes
Added 2 records successfully
Added 20000 records successfully

On Samba 4.10: 0m01.231s
On 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?


	Andreas


-- 
Andreas Schneider                      asn at samba.org
Samba Team                             www.samba.org
GPG-ID:     8DFF53E18F2ABC8D8F3C92237EE0FC4DCC014E3D