You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2026/07/11 06:45:00 UTC
[jira] [Commented] (SYNCOPE-1982) Slow query on OraclePlainSchemaRepoExtImpl
[ https://issues.apache.org/jira/browse/SYNCOPE-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18095496#comment-18095496 ]
ASF subversion and git services commented on SYNCOPE-1982:
----------------------------------------------------------
Commit f787db8a69cd6d9f8bde1550a60c2f7a54ae6827 in syncope's branch refs/heads/4_1_X from Valerio Crescia
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=f787db8a69 ]
[SYNCOPE-1982] Improve query perfomance on OraclePlainSchemaRepoExtImpl (#1450)
> Slow query on OraclePlainSchemaRepoExtImpl
> ------------------------------------------
>
> Key: SYNCOPE-1982
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1982
> Project: Syncope
> Issue Type: Improvement
> Components: core
> Affects Versions: 4.0.6, 4.1.1
> Reporter: Valerio Crescia
> Assignee: Francesco Chicchiriccò
> Priority: Major
> Fix For: 4.0.7, 4.1.2, 5.0.0
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> The two methods named existsPlainAttrUniqueValue use slow query on large dataset.
> {code:java}
> SELECT COUNT(id) FROM SyncopeUser,JSON_TABLE(plainAttrs, '$[*]?(@.schema == "codiceFiscale").uniqueValue' COLUMNS uniqueValue PATH '$.stringValue') AS codiceFiscale WHERE codiceFiscale.uniqueValue=?1 AND id <> ?2 {code}
> On Syncope installation with two hundred thousand users the query takes three seconds and It's become bootleneck for system perfomance with Oracle database.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)