My Oracle Support Banner

OUD 11g / 12c - Improving Search Performance When ModifyTimeStamp Used Within Search Filter (Doc ID 2427263.1)

Last updated on JULY 16, 2020

Applies to:

Oracle Unified Directory - Version 11.1.2.3.0 and later
Information 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


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