Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-23244

Quartz Triggers page always does a full table scan.

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 10.0
    • Component/s: Quartz Scheduler
    • Labels:
      None
    • 2.9 Status:
      Merge
    • Conversion Script Required:
      Yes

      Description

      Currently the trigger event list in the Job Scheduler tool is always sorted by eventTime but there isn't a index on this column so the order by ends up scanning the whole table. Creating an index means the inital load of the tool is always fast.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  buckett Matthew Buckett
                  Reporter:
                  buckett Matthew Buckett
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration