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

Improve slow TBX import of huge TBX files

    XMLWordPrintable

Details

    • Critical
    • For users with large amount of terminology: due a DB collation change the SQL file of this fix may run several minutes.
    • Due a improvement in TBX term ID handling, the import performance for bigger TBX files was reduced. This is repaired now.

    Description

      problem

      The import of a 2GB TBX import was still on 30% after 20 hours.

      reason

      It seems that some queries were not optimal regarding the DB indexes used.

      solution

      Improve indexes / index usage.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. TRANSLATE-2689 TBX import fails because of some ID error

          • Done

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: