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

[Fabio Martelli (Jira)]

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)