Valerio Crescia created SYNCOPE-1982:
----------------------------------------
Summary: 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.1.1, 4.0.6
Reporter: Valerio Crescia
Fix For: 4.1.2
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)
