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

    XMLWordPrintable

    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

          Zeplin

            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 Integration