Issue 7514 - Optimize OpenLDAP with paged results
Summary: Optimize OpenLDAP with paged results
Status: UNCONFIRMED
Alias: None
Product: OpenLDAP
Classification: Unclassified
Component: slapd (show other issues)
Version: 2.4.33
Hardware: All All
: --- normal
Target Milestone: ---
Assignee: OpenLDAP project
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-30 21:34 UTC by Quanah Gibson-Mount
Modified: 2020-09-21 22:37 UTC (History)
0 users

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Quanah Gibson-Mount 2013-01-30 21:34:35 UTC
Full_Name: Quanah Gibson-Mount
Version: 2.4.33
OS: Linux 2.6
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (74.196.25.250)


Currently, searches of back-mdb using paged results are extremely slow.  Up to
300 times slower than when not using paged results:

Without paged results:

 time  ldapsearch -LLL -x -H ldap://zre-ldap002.eng.vmware.com -b
"ou=people,dc=xxxx,dc=com" -s sub -D uid=zimbra,cn=admins,cn=zimbra -w zimbra
'(objectClass=zimbraAccount)' uid

real    0m0.004s
user    0m0.010s
sys     0m0.000s

With paged results:

zimbra@zre-ldap002:~$ time  ldapsearch -LLL -x -H
ldap://zre-ldap002.eng.vmware.com -b "ou=people,dc=xxxxx,dc=com" -s sub -D
uid=zimbra,cn=admins,cn=zimbra -w zimbra '(objectClass=zimbraAccount)' uid -E
pr=1000

real    0m1.204s
user    0m0.010s
sys     0m0.000s


Using paged results is fairly standard in Java clients, to prevent them from
hitting OOME's based on the way in which results are returned into a single
object.
Comment 1 Quanah Gibson-Mount 2017-04-03 17:25:06 UTC
moved from Incoming to Software Enhancements