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

database view extremely slow after upgrade

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9.3
    • 1.9
    • Database activity module
    • None
    • SLES 10, MySQL 5.0.26,
      SELECT COUNT(*) FROM moodle.mdl_data_content -> 25220
    • MySQL
    • MOODLE_19_STABLE
    • 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

            stronk7 Eloy Lafuente (stronk7)
            martinmai Martin Mai
            Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              3/Mar/08