Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-9652

Backport OPENIDM-9045: Performance problem getting triggers for a scheduler job

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: OpenIDM 4.0.0, OpenIDM 4.5.0, OpenIDM 5.0.0, OpenIDM 5.5.0
    • Fix Version/s: OpenIDM 5.0.0.2
    • Component/s: Module - Scheduler
    • Labels:

      Description

      When retrieving triggers for a scheduler job we retrieve each and every existing trigger with an individual database call to compare its job name to the name of the job for which we are retrieving the triggers. This will get very slow when there is a large number of triggers in the system.

      This results in a problem when a large number of users is added with temporary constraint. With thousand of users already added it was observed that it takes about 30 seconds to add any additional user.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mark.offutt Mark Offutt
                Reporter:
                mark.offutt Mark Offutt
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: