----------------------------------------
Date: Tue, 28 May 2013 16:13:29 +0000 From: hyc@symas.com To: openldap-its@openldap.org Subject: Re: (ITS#7610) scope index isn't used correctly with the filter index
meike.stone@googlemail.com wrote:
Full_Name: Meike Stone Version: 2.4.33 OS: Linux URL: ftp://ftp.openldap.org/incoming/ Submission from: (NULL) (193.200.138.3)
I have a directory with about 2,000,000 objects at all.
In one conteiner (basedn for search) are about 84,000 objects but only one of this is a person with objectclass=inetOrgperson. I have about 420,000 objectclass=inetOrgperson.
The search with the specified basedn where only the one inetOrgperson is located needs about 5 minutes ...
see: http://www.openldap.org/lists/openldap-technical/201305/msg00210.html
Sorry, digging further into the code I see I was mistaken. The two indices are being combined correctly and the code works in my own tests.
The search looks up the scope index (IDs of all the entries in the target scope) and the filter indices and computes their intersection. Not sure why this would be so slow in your case.
This sounds very similar to problem I was having, and I had to increase BDB_IDL_LOGN to 18 for the (rebuilt) objectclass index to be used.
Chris