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
