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

Add an index on the BULLHORN_ALERT table, on columns TO_USER and ALERT_TYPE.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 12.6, 19.2, 20.0
    • Fix Version/s: 20.0
    • Component/s: Portal Bullhorns
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      Add an index on the BULLHORN_ALERT table, on columns TO_USER and ALERT_TYPE. Bullhorns queries can get slow on big tables and there can be a lot of queries in large Sakai installations.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  a.fish@lancaster.ac.uk Adrian Fish
                  Reporter:
                  a.fish@lancaster.ac.uk Adrian Fish
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration