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

Posted to dev@syncope.apache.org by "Fabio Martelli (Jira)" <ji...@apache.org> on 2021/01/11 21:27:00 UTC

[jira] [Created] (SYNCOPE-1609) Reduce the number of table joins into PostgreSQL JSONB persistence implementation

Fabio Martelli created SYNCOPE-1609:
---------------------------------------

             Summary: Reduce the number of table joins into PostgreSQL JSONB persistence implementation
                 Key: SYNCOPE-1609
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1609
             Project: Syncope
          Issue Type: Improvement
          Components: core
    Affects Versions: 2.1.8
            Reporter: Fabio Martelli
             Fix For: 2.1.9


By exploiting new JSON Functions and Operators provided with PostgreSQL 12 it would be possible to remove several useless joins in order to improve user and any object search performance.

 

Take a look at "*JSON Processing Functions*" into [1].

 

[1]https://www.postgresql.org/docs/12/functions-json.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)