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

            Assignee:
            Unassigned
            Reporter:
            antonella Antonella Cirigliano
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: