Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-3577

Missing DB indizes are leading to long running analysis

    XMLWordPrintable

Details

    • Critical
    • Due a missing DB index the analysis and pre-translation was taking to much time.

    Description

      problem

      On saving a segment the meta data cache is also updated. Due a missing DB index when changing segment addressing by TRANSLATE-3303 from transunitId to transunitHash on each segment save all segments of a task were searched through two times.

      This was leading to a very long running operation finishing worker which was doing a save per each segment.

      solution

      Optimize segment meta table index.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. TRANSLATE-3303 Generated mid is not unique enough

          • Done

          Activity

            People

              tlauria Thomas Lauria
              tlauria Thomas Lauria
              Aleksandar Mitrev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: