[
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)
