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

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SYNCOPE-1609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17263141#comment-17263141 ] 

ASF subversion and git services commented on SYNCOPE-1609:
----------------------------------------------------------

Commit ffbe1fc8c3b607f2c21f059aadbaf59be470d3f9 in syncope's branch refs/heads/2_1_X from Fabio Martelli
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=ffbe1fc ]

[SYNCOPE-1609] Changes jsonb queries in order to improve performances (#233)



> 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
>            Assignee: Fabio Martelli
>            Priority: Major
>              Labels: jsonb, postgresql
>             Fix For: 2.1.9, 3.0.0
>
>
> 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)