[SYNCOPE-400] Poor search performance on MySQL

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.0.8, 1.1.2
• Fix Version/s: 1.1.3, 1.2.0-M1
• Component/s: core
• Environment: MySQL
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 11/Jul/13 09:35
• Updated: 12/Jul/13 07:02
• Resolved: 11/Jul/13 11:24

Description

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
[2] https://svn.apache.org/repos/asf/syncope/branches/1_1_X/core/src/main/java/org/apache/syncope/core/persistence/dao/impl/AttributableSearchDAOImpl.java