Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-9763

Reduce time spent on DB migration steps hotspot

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.6-M1, 6.6
    • Component/s: Database
    • Labels:

      Description

      Steps oracle25   psql25   psql50
      Total 351 % 306 % 491 %
      1267 123 35 94 31 141 29
      1217 98 28 32 10 45 9
      1202 31 9 46 15 102 21
      1271 2 2 26 8 41 8

      Oracle10M
      7h21 on 6.6.0.29113

      Steps # Duration
      1267 128
      1207 84
      1217 56
      1276 40
      1220 34
      1714 24

      Oracle25M
      5h51 on SQ 29533

      #1267 123 minutes
      #1217 98 minutes
      #1202 31 minutes
      #1714 24 minutes
      #1241 9 minutes

      SQLServer 10M
      4h36 on 6.6.0.29371

      Steps # Minutes
      #1217 72 minutes
      #1267 60 minutes
      #1714 25 minutes
      #1270 20 minutes
      #1219 13 minutes
      #1202 12 minutes
      #1517 10 minutes

      SQLServer 10M with optimisation is slower
      5h43 on 6.6.0.29533

      Steps # Minutes
      #1267 120 minutes
      #1217 74 minutes
      #1714 26 minutes
      #1270 17 minutes
      #1202 14 minutes
      #1219 13 minutes
      #1517 11 minutes

      Mysql 10M issues migration
      6h46 on SQ 6.6.0.29353

      Step # Duration in Min
      1270 40
      1267 39
      1207 37
      1276 36
      1265 32
      1219 28
      1220 28
      1216 25
      1217 25

      Mysql 25M
      10h43 on SQ 6.6.0.29353

      Steps # Minutes
      #1270 39 minutes
      #1267 39 minutes
      #1207 36 minutes
      #1276 36 minutes
      #1265 32 minutes
      #1219 27 minutes
      #1220 27 minutes
      #1217 25 minutes
      #1216 25 minutes
      #1202 17 minutes

      Postgres 10M
      3h18 on 6.6.0.29113

      Steps # Minutes
      #1267 61 minutes
      #1217 23 minutes
      #1202 20 minutes
      #1271 17 minutes
      #1221 14 minutes
      #1714 11 minutes

      Postgres 25M
      5h06 on 6.6.0.29371

      Steps # Minutes
      1267 94
      1202 46
      1217 32
      1271 26
      1221 19
      1714 11

      Postgres 50M
      8h11 on 6.6.0.29499

      #1267 141 minutes
      #1202 102 minutes
      #1217 45 minutes
      #1271 41 minutes
      #1221 29 minutes
      #1257 11 minutes
      #1714 11 minutes

        Attachments

          Activity

            People

            Assignee:
            simon.brandhof Simon Brandhof (Inactive)
            Reporter:
            thomas.verin Thomas VĂ©rin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: