[
https://issues.apache.org/jira/browse/SYNCOPE-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18095497#comment-18095497
]
ASF subversion and git services commented on SYNCOPE-1982:
----------------------------------------------------------
Commit d0e16b0c15a1d3308e601b7ea8d77f672777f3fc in syncope's branch
refs/heads/4_0_X from Valerio Crescia
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=d0e16b0c15 ]
[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)
