Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-24593 Database query performance improvements
  3. SAK-24609

Rewrite synoptic queries to separate permissionLevelId query from permissionLevelName

    Details

    • Type: Sub-task
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.7.1
    • Fix Version/s: 2.7.2, 2.8.0
    • Component/s: Messages Tool
    • Labels:
      None

      Description

      Seeing some of these queries take 685 seconds on a MySQL db. Splitting the queries into two produces one query at 3.5 seconds and one query at 5.5 seconds.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ottenhoff Sam Ottenhoff
                Reporter:
                ottenhoff Sam Ottenhoff
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code