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

Performance regression on document deletion under Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Incomplete
    • Affects Version/s: 5.5
    • Fix Version/s: None
    • Component/s: Core VCS
    • Environment:
      oracle 10g

      Description

      Problem reported on answers by Romain France
      """
      We can't delete document since we've upgrade nuxeo 5.4.2 to 5.5 (DataBase Oracle 10G). It doesn't work anymore with Nuxeo GUI, API Java or REST API.

      It seems that this request (operated bi Nuxeo) is very slow :

      SELECT "HIERARCHY"."ID", "HIERARCHY"."PARENTID", "HIERARCHY"."PRIMARYTYPE", "HIERARCHY"."ISPROPERTY", "PROXIES"."VERSIONABLEID", "PROXIES"."TARGETID" FROM "HIERARCHY" LEFT JOIN "PROXIES" ON "HIERARCHY"."ID" = "PROXIES"."ID" WHERE EXISTS(SELECT :"SYS_B_0" FROM ancestors WHERE hierarchy_id = "HIERARCHY"."ID" AND :1 MEMBER OF ancestors)

      """

        Attachments

          Activity

            People

            • Assignee:
              bdelbosc Benoit Delbosc
              Reporter:
              bdelbosc Benoit Delbosc
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: