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

DropBox Performance Problems

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4.0, 2.4.1
    • Fix Version/s: 2.4.x, 2.5.0
    • Component/s: Drop box
    • Labels:
      None
    • Environment:
      Linux-Oracle

      Description

      The response Time of the Dropbx tool for medium-large sites is very slow.

      On our test it was:
      With a course of 600 students it took 5 minutes to reply and the IE needed 100Mb of RAM.
      With a course of 370 students it took 3 minutes to reply and the IE needed 80Mb of RAM.
      With a course of 180 students it took 2.5 minutes to reply and the IE needed 65Mb of RAM.
      With a course of 50 students it took 35 sec to reply and the IE needed 35Mb of RAM.

      Our Test Database is a migrated copy from 2.12 to 2.4 with this numbers:
      Num records in COTENT_COLLECTION Table ...:4802,754
      Num records in COTENT_RESOURCE Table ...:103,377
      Num records in COTENT_RESOURCE_BODY_BINARY Table ...:103,110

      We have seen all these database activity accessing a DropBox of 647 Students
      I post it in the attach file database.txt

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              is related to

              Bug - A problem which impairs or prevents functionality of the product. SAK-9887 Excessive db queries for dropbox on site update actions

              • Critical - Crashes, loss of data, severe memory leak, need functionality ASAP in production.
              • CLOSED

              Bug - A problem which impairs or prevents functionality of the product. SAK-10171 Resources and DropBox permance problem caused in part by form-item query

              • Critical - Crashes, loss of data, severe memory leak, need functionality ASAP in production.
              • CLOSED
              relates to

              Bug - A problem which impairs or prevents functionality of the product. SAK-10145 Resources can not be seen in admin resources area.

              • Blocker - Blocks development and/or testing work, production could not run without this feature working correctly.
              • CLOSED

              Bug - A problem which impairs or prevents functionality of the product. SAK-10779 Performance - Rendering of top level resources view needs improvement

              • Blocker - Blocks development and/or testing work, production could not run without this feature working correctly.
              • CLOSED

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  rmengod Raúl E. Mengod López
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration