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, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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