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

Need composite index on MFR_PERMISSION_LEVEL_T

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.2
    • Fix Version/s: 12.0
    • Component/s: Forums Tool
    • 11 status:
      Please Merge

      Description

      Seen in production. Need MFR_PERMISSION_LEVEL_T with 900k+ rows. A lot of queries like this :

      select straight_join count(*) as NBR from MFR_AREA_T area 
      inner join MFR_OPEN_FORUM_T openforum on openforum.surrogateKey=area.ID 
      inner join MFR_TOPIC_T topic on topic.of_surrogateKey=openforum.ID inner join MFR_MEMBERSHIP_ITEM_T membership on topic.ID=membership.t_surrogateKey, 
      MFR_PERMISSION_LEVEL_T permission where area.CONTEXT_ID = 'ab6017e2-cd27-4e37-a0c4-22d38e1c7d32' and topic.MODERATED = true and (membership.NAME in ( 'Student', 'XXXXXXXXXXXXX.499.01.Sp17' ) 
      and permission.MODERATE_POSTINGS = true and permission.TYPE_UUID <> '5927e5d7-355c-4d7e-b7b5-e4e8cd1e32ac' and permission.NAME=membership.PERMISSION_LEVEL_NAME)
      

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                • Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  ottenhoff Sam Ottenhoff
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Integration