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

Make table PROPERTIES store values in a VARCHAR column and use a CLOB only if too big

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.1
    • Component/s: Database
    • Labels:

      Description

      Currently, values of properties are stored in table PROPERTIES exclusively in a CLOB.

      While this allows to support properties which value is bigger than 4000 chars, this is not efficient when retrieving the information where only very rare properties exceed this limit.

      We should rather use a CLOB only when needed and by default store the value of properties in a VARCHAR column.

      So:

      1. add column PROPERTIES.TEXT_VALUE_OVERFLOW of type CLOB (nullable)
      2. this column should be populated with the value of PROPERTIES.TEXT_VALUE when it's size is > 4000. In this case, PROPERTIES.TEXT_VALUE should set to null
      3. change type of column PROPERTIES.TEXT_VALUE from CLOB to VARCHAR and keep it nullable

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sebastien.lesaint Sebastien Lesaint
              Reporter:
              sebastien.lesaint Sebastien Lesaint
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: