Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-968

Cronjob to send notifications emails used a slow query

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.4.0
    • Component/s: Notifications
    • Labels:
      None

      Description

      The process to send notifications emails was optimize to save memory on the java side, but the paged query is slow on Postgres due to the order by. The idea is to page all users instead of all subscribers, the order by primary is quick and the memory usage stay low.

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Kirsten Scherer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours
                5h