[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Worse search performance on a branch than at the tree base
Glover, Matthew wrote:
> I'm having a performance problem with searches on a branch and I'm hoping someone can explain it.
>
> A search for "(uid=12345)" on basedn "dc=example,dc=com" with a subtree scope returns much more quickly than the same filter and scope on basedn
> "ou=People,dc=example,dc=com".
Sounds vaguely like ITS#7473 but that was fixed 5 years ago. Maybe your index is not configured?
>
> To confirm this wasn't just a problem with my schema or configuration, I loaded Ubuntu 18 (slapd 2.4.45+dfsg-1ubuntu1), used ldctl to generate 100,000
> inetOrgPerson records with uids from 00000 to 99999, loaded them in with ldapadd, then used ldctl to test performance of searches:
>
> Both tests were scope subtree, 20 seconds, hitting the test server as fast as possible with randomly generated filters of "(uid=<random uid from 00000 to 99999>)".
> basedn: dc=example,dc=com - 5455.30/sec - total: 109106 successful searches
> basedn: ou=People,dc=example,dc=com - 198.80/sec - total: 3976 successful searches
>
> Also, while testing against ou=People, the CPU load from slaps went through the roof. It feels rather like the index isn’t being used when the base isn’t the
> root.
>
> I can provide the ldif of my test users and the parameters I used for ldctl tests if desired.
>
>
> Thanks for any help you can offer,
> Matthew
--
-- Howard Chu
CTO, Symas Corp. http://www.symas.com
Director, Highland Sun http://highlandsun.com/hyc/
Chief Architect, OpenLDAP http://www.openldap.org/project/