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

Performance problems with background SQL queries in Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: Global
    • Labels:
      None
    • Environment:
      Sakai with Oracle

      Description

      Certain SQL commands and settings were found to be major performance problems with CTools' Oracle. These were:

      • validating the db connection with a simple SQL statement
      • setting the default transaction isolation level

      (Note: doing a rollback after each connection use, and setting the auto-commit each time to the default value were also a problem and have been fixed already in the TRUNK)

      Changes were put in CTools to address this, but the kernel db configuration was not structured to allow these changes to be applied to the TRUNK, so that the OOTB Sakai supports HSQLDB with these settings, and for Oracle, we can disable them as needed in the sakai.properties files.

      Change the kernel db configuration to allow this, and recommend the Oracle settings (here, and in the various distributed properties files and examples).

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                ggolden@umich.edu Glenn R. Golden (Inactive)
                Reporter:
                ggolden@umich.edu Glenn R. Golden (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration