Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-42188

Improve Announcement performance

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: RESOLVED
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 12.7, 19.2, 20.0 [Tentative]
    • Fix Version/s: 20.0 [Tentative]
    • Component/s: Announcements
    • Labels:
    • 19 status:
      Please Merge
    • 12 status:
      Please Merge
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      We are having performance issues with this BD query:

      select XML
      from ANNOUNCEMENT_MESSAGE
      where (CHANNEL_ID = :1  )
      order by MESSAGE_DATE asc
      

      This query is related to the tool sakai.synoptic.announcement.

      We have studied this problem and since the query is executed hundred of thousands times per day, we have decided to implement a cache to reduce the amount of executions.

       

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  adrianmticarum Adrian Martinez
                  Reporter:
                  adrianmticarum Adrian Martinez
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code