[ https://issues.apache.org/jira/browse/SYNCOPE-1609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francesco Chicchiriccò updated SYNCOPE-1609: -------------------------------------------- Labels: jpa-json jsonb postgresql (was: jsonb postgresql) > 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: jpa-json, 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)