You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@syncope.apache.org by "Valerio Crescia (Jira)" <ji...@apache.org> on 2026/07/10 13:16:00 UTC

[jira] [Created] (SYNCOPE-1982) Slow query on OraclePlainSchemaRepoExtImpl

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)