[
https://issues.apache.org/jira/browse/SYNCOPE-1609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17263158#comment-17263158
]
ASF subversion and git services commented on SYNCOPE-1609:
----------------------------------------------------------
Commit fca4bdbd08746b926bdb1d78f653a476ca1d9dbb in syncope's branch
refs/heads/master from Fabio Martelli
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=fca4bdb ]
[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)
