[
https://issues.apache.org/jira/browse/SYNCOPE-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò reassigned SYNCOPE-1982:
-----------------------------------------------
Assignee: Francesco Chicchiriccò
> 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: 10m
> 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)
