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

Adding a Collection to an instance with a lot of sites takes forever (5 -10 minites )

    XMLWordPrintable

    Details

      Description

      Reported by

      On Apr 24, 2007, at 5:23 AM, Raúl Enrique Mengod López wrote:

      > Hi all!
      >
      >
      >
      > Has anyone test the trunk / 2.4QA12 version with a large database
      > full of resources?
      >
      >
      >
      > We are detecting some performance problems affecting those versions
      > a couple weeks ago.
      >
      >
      >
      > We have a trunk instance running normally against a clean oracle
      > database.
      >
      > But when we connect this instance to our production database
      > migrated to 2.4 it takes a lot of time (5 to 10 min) to do any
      > action like create folder on resources.
      >
      > It works fine with displaying the list of resources or accessing to
      > a previously created resource.
      >
      >
      >
      > The symptoms are many activity on the oracle processes (all of
      > them) and also many activity on tomcat (the GC displays status
      > every 2 seconds).
      >
      >
      >
      > We have trace the database looking for heavy queries but we haven't
      > found anything, so we think the problem may be in the java code.
      >
      >
      >
      > We are not sure it this problem is due to our instance or it is a
      > real problem on the code.
      >
      >
      >
      > Could it be any migration problem or configuration problem???
      >
      >
      >
      > Any idea to track the problem will be appreciated.
      >
      >
      >
      > Thanks
      >
      > ----------------------------------------------------------------------
      > ------------
      >
      > Raúl E. Mengod López
      >
      > Analista de Sistemas / Aplicaciones
      >
      > Área de Sistemas de Información y Comunicaciones
      >
      > Universidad Politécnica de Valencia
      >
      > ----------------------------------------------------------------------
      > ------------

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                ianeboston Ian Boston
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration