You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/07/11 15:03:49 UTC
[jira] [Commented] (SYNCOPE-400) Poor search performance on MySQL
[ https://issues.apache.org/jira/browse/SYNCOPE-400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13705778#comment-13705778 ]
Hudson commented on SYNCOPE-400:
--------------------------------
Integrated in Syncope-trunk #247 (See [https://builds.apache.org/job/Syncope-trunk/247/])
[SYNCOPE-400] Merge from 1_1_X (Revision 1502188)
Result = SUCCESS
ilgrosso :
Files :
* /syncope/trunk
* /syncope/trunk/core/src/main/java/org/apache/syncope/core/persistence/dao/impl/AttributableSearchDAOImpl.java
* /syncope/trunk/core/src/main/resources/views.xml
> 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.0.8, 1.1.2
> 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
> [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
--
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