Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15371

Very slow notification display performances in some cases

    XMLWordPrintable

    Details

    • Difficulty:
      Unknown
    • Similar issues:

      Description

      On myxwiki.org I've noticed that whenever I was going to my subwiki and clicking the bell icon, the notifications area kept spinning forever. I actually only waited 3 minutes before stopping.

      see the attached video to visualize what I experiment there.

      Note that myxwiki.org has a lot of subwikis and it's using the default config for the activitystream storage.

      On the main DB (xwiki):

      mysql> SELECT COUNT(*) FROM activitystream_events;
      +----------+
      | COUNT(*) |
      +----------+
      |   680499 |
      +----------+
      1 row in set (3.78 sec)
      

      Funily if I do the same query on my subwiki DB (i.e. massol) it's not empty:

      mysql> SELECT COUNT(*) FROM activitystream_events;
      +----------+
      | COUNT(*) |
      +----------+
      |    15388 |
      +----------+
      1 row in set (0.19 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gdelhumeau Guillaume Delhumeau
              Reporter:
              vmassol Vincent Massol
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response: