Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3442

review table indexes in hotpot tables

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.9.11
    • Fix Version/s: None
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      Eloy spotted this query that might need some optimization

      3) SELECT
      h.id AS id,
      h.name AS name,
      COUNT AS count_attempts
      FROM
      hotpot h,
      hotpot_attempts a
      WHERE
      h.course = 34
      AND h.id = a.hotpot
      AND a.id = a.clickreportid
      AND a.starttime > 1187805492
      GROUP BY
      h.id, h.name;
      (not really often but happens)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                xxxxxxx Gordon Bateson
                Reporter:
                skodak Petr Skoda
                Participants:
                Component watchers:
                Gordon Bateson
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: