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 2013/07/11 11:35:50 UTC

[jira] [Created] (SYNCOPE-400) Poor search performance on MySQL

Francesco Chicchiriccò created SYNCOPE-400:
----------------------------------------------

             Summary: Poor search performance on MySQL
                 Key: SYNCOPE-400
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-400
             Project: Syncope
          Issue Type: Bug
          Components: core
    Affects Versions: 1.1.2, 1.0.8
         Environment: MySQL
            Reporter: Francesco Chicchiriccò
            Assignee: Francesco Chicchiriccò
            Priority: Critical
             Fix For: 1.1.3, 1.2.0


As reported from different deployment environments, searching users and roles when using MySQL for internal storage shows very poor performance.

This is with any evidence due to bug [1], open since 2010, and is related to the "UNION ALL" construct used to define SQL search views, on which AttributableSearchDAOImpl [2] is based.

Such views definition needs to be changed in order to avoid at all the "UNION ALL" construct.

[1] http://bugs.mysql.com/bug.php?id=56225

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira