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
    • Fix Version/s: 20.0
    • 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

          Zeplin

            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 Integration