Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-63954

Moodle + Oracle: query for each connection

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5, 3.5.1, 3.5.2
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Affected Branches:
      MOODLE_35_STABLE

      Description

      Our Moodle is running on Oracle because of internal policies. The installation is very large.

      It happens that the cron operation is heavy and slow, so, consequently, all the connections (1000 simultaneous) are slow when executing the query:
      SELECT 1

      FROM user_objects

      WHERE object_type = 'PACKAGE BODY'

      AND object_name = 'MOODLELIB'

      ....

      Is it possible to remove the function oci_package_installed from the connection operation (keeping it only during installation or upgrade)?

      the file is lib/dml/oci_native_moodle_database.php

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: