Uploaded image for project: 'Moodle Community Sites'
  1. Moodle Community Sites
  2. MDLSITE-2670

Ineffective storage of string texts in AMOS

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Low
    • Resolution: Done
    • lang.moodle.org
    • None

    Description

      The current database scheme for AMOS needs to be normalized and optimized a bit. Currently, we store the actual string texts per branch. No surprise the database size is more than 7GB now as we effectively copy all the texts every six months.

      The idea is to have a single table for actual string texts (with sha1 hash) that would be 1:N referenced from the amos_repository table.

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDLSITE-6243 Ineffective storage of string texts in AMOS (still)

          • Medium -
          • Resolved

          Activity

            People

              mudrd8mz David Mudrák (@mudrd8mz)
              mudrd8mz David Mudrák (@mudrd8mz)
              David Mudrák (@mudrd8mz)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: