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

Series index query performs bad on system with many series

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed and reviewed
    • Affects versions: 3.0
    • Fix versions: 3.1
    • Components: Backend Software

      Description

      When loading the Admin UI Events tab, the filter data is also loaded. These takes some time (8+ sec) on systems with many series defined. Same bad performance happen requesting the event metadata.json.

      On both screenshots you can see the request to the filter.json and the metadata.json need 8+ seconds for a response. The testsystem has 1000 series defined.
      Internally the SeriesListProvider is called for a list of all series in the system. The call take the most of time.

      I've added a bash script to attachments. It will create 1000 series for testing. Here you can find a script to create a large series range for testing in more comfortable way.

        TestRail: Results

          Attachments

            Issue links

              Activity

                People

                • Assignee:
                  wsmirnow Waldemar Smirnow (Inactive)
                  Reporter:
                  wsmirnow Waldemar Smirnow (Inactive)
                • Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    TestRail: Cases