Mailing-List: contact dev-help@directory.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Directory Developers List" <dev@directory.apache.org>
Date: Wed, 17 Aug 2016 08:41:20 +0000 (UTC)
From: "Emmanuel Lecharny (JIRA)" <jira@apache.org>
To: dev@directory.apache.org
Message-ID: <JIRA.12995608.1470653549000.327310.1471423280835@Atlassian.JIRA>
In-Reply-To: <JIRA.12995608.1470653549000@Atlassian.JIRA>
References: <JIRA.12995608.1470653549000@Atlassian.JIRA> <JIRA.12995608.1470653549136@arcas>
Subject: [jira] [Commented] (DIRSERVER-2162) Searcing for users using
 ObjectClass=person takes long
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 17 Aug 2016 08:41:22 -0000


    [ https://issues.apache.org/jira/browse/DIRSERVER-2162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15424124#comment-15424124 ] 

Emmanuel Lecharny commented on DIRSERVER-2162:
----------------------------------------------

We don't assign a version until we have a clear fix.

For the record, I did some test with 1000 entries, but I don't see a big difference even when I don't create the set of candidates for the {{(objectClass=person)}} filter (which was supposedly taking some time). There must be something wrong going on elsewhere, and I continue to investigate the problem.

In any case, using a substring filter like {{\*xyz\*}} or even {{\*xyz}} is not a good idea. There is no solution that could be performant and cover all the use cases.

> 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
>    Affects Versions: 2.0.0-M20
>            Reporter: John Peter
>
> 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
(v6.3.4#6332)