My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.