Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-1538

Add index to o_loggingtable

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3
    • Component/s: None
    • Labels:
      None

      Description

      These 5 index speed up the course archive with a factor 1000:

      create index log_target_resid_idx on o_loggingtable(targetresid);
      create index log_ptarget_resid_idx on o_loggingtable(parentresid);
      create index log_gptarget_resid_idx on o_loggingtable(grandparentresid);
      create index log_ggptarget_resid_idx on o_loggingtable(greatgrandparentresid);
      create index log_creationdate_idx on o_loggingtable(creation date);

      As example setting these index on a 3GB table takes 1 minute and 1 minute 30 seconds per index and the size of the index is 500MB for the five index + primary key on MySQL.

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              srosse Stéphane Rossé
              Tester:
              Florian Gnägi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 30 minutes
                30m