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

Quartz Triggers page always does a full table scan.

    XMLWordPrintable

    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

          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 Source Code