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

Portfolio performance issues when selecting items for templates that have many forms as item defs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.4.0, 2.4.1, 2.5.0, 2.5.2, 2.5.3
    • Fix Version/s: None
    • Component/s: OSP: Portfolios
    • Labels:
      None

      Description

      when a template using a number of form defs as items, we've found that the page where you select items can be very slow, to the point where is eventually times out. I've traced this down to a method is CHS that loads and filters the resources. It turns out that while sakai caches site info, tool info is not cached. This was causing a huge number of extra queries against the sakai_site_tool table.

      select TOOL_ID, REGISTRATION, TITLE, LAYOUT_HINTS, PAGE_ORDER from SAKAI_SITE_TOOL where PAGE_ID = ? order by PAGE_ORDER ASC

        Gliffy Diagrams

          Zeplin

            Attachments

            1. Douglass Matrix.zip
              67 kB
            2. Douglass Portfolio Template 2.zip
              48 kB
            3. Home+and+About+Me+Pages.zip
              24 kB
            4. Leadership+Transcript.zip
              24 kB
            5. My+Pathway.zip
              13 kB
            6. Resume+Builder.zip
              18 kB
            7. SAK-13791_fix_performance_issue.patch
              3 kB

              Issue Links

                Activity

                  People

                  • Assignee:
                    jbush John Bush
                    Reporter:
                    jbush John Bush
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Integration