[jira] [Commented] (SYNCOPE-983) Search performance improvement with mandatory schemas only

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

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

ASF subversion and git services commented on SYNCOPE-983:
---------------------------------------------------------

Commit 9bc75f24fd80f3c7cab62a86c4a79a27e20460b8 in syncope's branch refs/heads/1_2_X from [~ilgrosso]
[ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=9bc75f2 ]

[SYNCOPE-983] Improving search performance by skipping unnecessary checks for mandatory schemas and when the query is performed by admin


> Search performance improvement with mandatory schemas only
> ----------------------------------------------------------
>
>                 Key: SYNCOPE-983
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-983
>             Project: Syncope
>          Issue Type: Improvement
>          Components: core
>            Reporter: Francesco Chicchiriccò
>            Assignee: Francesco Chicchiriccò
>             Fix For: 1.2.10, 2.0.2, 2.1.0
>
>
> Currently, the internal search engine will always {{UNION}} the {{user_search_attr}} and {{user_search_null_attr}}.
> When attribute conditions and order clauses are specified that only require mandatory schemas, this UNION can be skipped, with general performance improvement.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)