OUD Search Performance - How to Improve "ldapsearch" when the "modifyTimeStamp" Attribute is Used within the Filter
(Doc ID 2427263.1)
Last updated on NOVEMBER 14, 2022
Applies to:
Oracle Unified Directory - Version 11.1.2.3.0 and laterInformation in this document applies to any platform.
Goal
The following search against a directory with one million entries takes approximately 28.9 seconds to complete...
$ time $OUD_HOME/OUD/bin/ldapsearch -h <HOST> -p <LDAP_PORT> -D 'cn=<DS_ADMIN>' -j <PASSWORD_FILE> -b dc=<SUFFIX_DN> -s sub '(&(modifyTimeStamp>=20151015012921Z)(modifyTimeStamp<=20151015012922Z)(objectClass=inetOrgPerson))' modifytimestamp
dn: uid=<USER.1>,ou=People,dc=<SUFFIX_DN>
modifytimestamp: 20151015012921Z
dn: uid=<USER.3>,ou=People,dc=<SUFFIX_DN>
modifytimestamp: 20151015012922Z
real 0m28.857s
user 0m0.543s
sys 0m0.037s
Is there a way to improve search performance in such cases where modifyTimeStamp is part of the search filter?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |