Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10216

Optimize complex list property update (no DELETE + INSERT)

    XMLWordPrintable

    Details

      Description

      Updating a complex list property triggers DELETE and INSERT SQL statements.
      This could be optimized using UPDATE statements (DELETE is quite costly because of the ON DELETE CASCADE option).
      Attached stack trace of such a call.

      In addition to being costly, on Microsoft SQL Server this may cause deadlocks, see the next comment.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.