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

database view extremely slow after upgrade

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.3
    • Fix Version/s: 1.9
    • Labels:
      None
    • Environment:
      SLES 10, MySQL 5.0.26,
      SELECT COUNT(*) FROM moodle.mdl_data_content -> 25220
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      After upgrading from moodle 1.8 to 1.9.3 views like
      http://vc.uni-bamberg.de/moodle/mod/data/view.php?id=67166
      became very slow (like 30 secs or longer). Load on the machine was 0.3 versus 0.8 when delivering such pages

      ALTER TABLE `moodle`.`mdl_data_content` ADD INDEX `fieldid`(`fieldid`);
      ALTER TABLE `moodle`.`mdl_data_content` ADD INDEX `recordid`(`recordid`);

      seemed to fix it

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              martinmai Martin Mai
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08