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/22 08:33:58 UTC

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

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

Francesco Chicchiriccò resolved SYNCOPE-983.
--------------------------------------------
    Resolution: Fixed

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