You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@syncope.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2016/12/20 14:33:00 UTC

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

Francesco Chicchiriccò created SYNCOPE-983:
----------------------------------------------

             Summary: 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)