Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-1609

Reduce the number of table joins into PostgreSQL JSONB persistence implementation

    XMLWordPrintableJSON

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fmartelli Fabio Martelli
                Reporter:
                fmartelli Fabio Martelli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: