• Thomas Bouffard's avatar
    feat(contractData): change serialization val column migration · fa9b5048
    Thomas Bouffard authored
    The previous implementation considered rows non already migrated. The query
    performed for that purpose was too slow: the columns in the WHERE clause
    weren't in indexes, so a full table scan was performed
    The new solution retrieve all table rows using the PRIMARY index, so this
    is faster but more rows are retrieved.
    This is not an issue because
      - the retrieved rows contain only id and tenantid, so heap size impact
      can be negligible (the order of magnitude is 10 millions of rows in the
      table)
      - the subsequent query retrieves the blob value to migrate
        - is very fast (also use PRIMARY index)
        - only retrieves the blob data when it has not been migrated, so no
        extra large data is retrieved from the db
    
    In addition, add way to skip serialization update of contract_data
    Can be useful in case we know that has already be done
    
    Covers [BS-19346](https://bonitasoft.atlassian.net/browse/BS-19346)
    fa9b5048
Name
Last commit
Last update
buildSrc Loading commit data...
gradle/wrapper Loading commit data...
src Loading commit data...
.gitignore Loading commit data...
README.md Loading commit data...
bonita.versions Loading commit data...
build.gradle Loading commit data...
gradlew Loading commit data...
gradlew.bat Loading commit data...
migration.properties Loading commit data...
settings.gradle Loading commit data...