[jira] [Resolved] (DIRSERVER-2162) Searcing for users using ObjectClass=person takes long

["Emmanuel Lécharny (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DIRSERVER-2162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Lécharny resolved DIRSERVER-2162.
------------------------------------------
    Resolution: Fixed

I don't when this was fixed, but with 2.0.0-M27, doing a search like {{(&(cn=name10*)(objectClass=person))}} when we have 20 000 entries which CN looks like {{name(i:1..20000)}} takes the same time than the search with the {{(cn=name10*)}} filter. More or less 800ms for 1111 results.

> Searcing for users using ObjectClass=person takes long
> ------------------------------------------------------
>
>                 Key: DIRSERVER-2162
>                 URL: https://issues.apache.org/jira/browse/DIRSERVER-2162
>             Project: Directory ApacheDS
>          Issue Type: Bug
>          Components: search
>    Affects Versions: 2.0.0-M20
>            Reporter: John Peter
>            Priority: Major
>             Fix For: 2.0.0.AM27
>
>
> When we do the below query the result takes long. Around 10-50 seconds.
> Search base: ou=users,dc=xxx,dc=fi
> Filter (&(cn=*USERNAME*)(objectClass=person))
> Scope: Subtree
> However the below query returns the result immediately
> Search base: ou=users,dc=xxx,dc=fi
> Filter (&(cn=*USERNAME*)(objectClass=*))
> Scope: Subtree
> Looking at the Partition settings it has Indexed attributes ObjectClass and cn.
> First both queries took long. Then we added cn to the index and rebooted apacheDS and the second query got fast.
> It seems like a bug that using ObjectClass in the query makes it slow all tough it is in the index.
> It seems something similar was reported before DIRSERVER-2048, but it says it's fixed in M20 which we are using.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@directory.apache.org
For additional commands, e-mail: dev-help@directory.apache.org