[
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)
