Uploaded image for project: 'Opencast'
  1. MH-13354

Asset Manager Property Performance

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 6.3
    • Fix versions: 6.5
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Performance
    • Steps to reproduce:
      Hide
      All asset manager delete queries suffer from very poor performance in
      large systems since they always probing for orphaned properties of any
      media packages and will always create a joined table of all snapshots
      and all properties in the process, even if it is completely unnecessary
      like in the case of updating the ACL properties.
      Show
      All asset manager delete queries suffer from very poor performance in large systems since they always probing for orphaned properties of any media packages and will always create a joined table of all snapshots and all properties in the process, even if it is completely unnecessary like in the case of updating the ACL properties.

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              lkiesow Lars Kiesow
              Reporter:
              lkiesow Lars Kiesow
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                TestRail: Cases