Uploaded image for project: '[Read Only] - Hippo Repository'
  1. [Read Only] - Hippo Repository
  2. REPO-258

Repository (and CMS/workflow) calls session refreshes too often causing high load on database servers (patch attached)

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • High
    • Resolution: Fixed
    • 2.18.06, 2.20.06, 2.21.05
    • 2.18.07, 2.20.07, 2.22.00
    • None
    • None

    Description

      Each call to session.refresh results in query on the database in a clustered setup. We should only make the call if it is really necessary and when there is no lightweight alternative. The clusternode itself already checks the database every 5 seconds for changes which should be often enough for most scenarios.

      An easy target to lower the number of refreshes is to make the LoadInitializationModule not call refresh every second. The attached patch seems to have no impact on normal operations.

      Other areas where the number of call might be reduced are the workflow with the cms related code and the quartz scheduler.

      Attachments

        Activity

          People

            jsheriff Junaidh Kadhar Sheriff
            bvdschans Bart van der Schans (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: