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

Dropbox performs poorly in large sites

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 20.0, 21.0 [Tentative]
    • Fix Version/s: None
    • Component/s: Drop box
    • Labels:
      None
    • Test Plan:
      Hide
      1. Visit the Drop box in a site with many users (over 1000), and ensure it loads within a reasonable timeframe.
      2. Ensure Drop box permissions are behaving appropriately (and I'd like as much information as possible about how Drop box permissions are intended to work)
      Show
      Visit the Drop box in a site with many users (over 1000), and ensure it loads within a reasonable timeframe. Ensure Drop box permissions are behaving appropriately (and I'd like as much information as possible about how Drop box permissions are intended to work)

      Description

      In a site with 5000 students, it takes 2 minutes and 50 seconds to load an empty dropbox against Oracle, and this time is proportional to class size, so:
      2000 students = 68 seconds
      1000 students = 34 seconds

      In my testing, the bottleneck is permission checks that are occurring for every entity, which follows a similar code path as regular Resources entities, then they are cached per entity which is unhelpful. It's worth noting thatĀ even though they're the same project in code, the permissions in Resources are far more complex than in Dropbox (so there is a lot of opportunity for performance gains), and Dropbox typically hosts more content than Resources.

      Reduce as many redundant permission checks as possible.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  bbailla2 Brian Baillargeon
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Git Integration