Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-39259

Unread private messages causes delay on page load time

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • None
    • 2.4.1, 2.4.2
    • Messages
    • MOODLE_24_STABLE

    Description

      Many of our users were complaining that Moodle load very slowly. They reported that it was taken 50-60 seconds to load a page. As an admin I didn't experience any delays. I checked the server and everything was normal. The only thing I found strange was an SQL log about slow queries. There, it was reported that a query that had to do with the pop-up notification was taking almost 20 sec to execute.

      1. Query_time: 32.899467 Lock_time: 0.000121 Rows_sent: 644 Rows_examined: 251193
        SET timestamp=1366548816;
        SELECT m.id, m.smallmessage, m.fullmessageformat, m.notification, u.firstname, u.lastname
        FROM mdl_message m
        JOIN mdl_message_working mw ON m.id=mw.unreadmessageid
        JOIN mdl_message_processors p ON mw.processorid=p.id
        JOIN mdl_user u ON m.useridfrom=u.id
        WHERE m.useridto = '1396'
        AND p.name='popup';

      Then I realized that what was different from my account and their account was the unread private messages/notification, I had none, they had many. So I told everyone to go to their private message and click on all of them to mark them as read. Many users had more than 300 unread messages, this solved the loading issue.

      Steps to reproduce:

      1. Create a users
      2. Enrol him in a course
      3. Generate notifications by using forums, assignments, private messaging
      4. Login as him/her. His/her account will load pages VERY slow. No matter on what OS, browser or anything else.

      Attachments

        Issue Links

          Activity

            People

              poltawski Dan Poltawski
              christos312 christos
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.