We have a big sized changesets in our liquibase patches(sql format).
Changesets look like this and have about 30000 strings each:
INSERT INTO Table1 (c1, c2, c3, Name, Active, Properties, Domain) VALUES
(‘SOME_VALUE’, ‘SOME_VALUE_2’, ‘’, ‘aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa’, true, ‘25472354725472534hsdfjhsgfjsd25472354725472534hsdfjhsgfjsd25472354725472534hsdfjhsgfjsd25472354725472534hsdfjhsgfjsd’, null),
…
(‘SOME_VALUE’, ‘SOME_VALUE_2’, ‘’, ‘adsasdasdasddddddddddddddddddddddddddddddddddddddddddddddddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaddddddddddddddddddddddddddddddddddddddddddddddd’, true, ‘25472354725472534hsdfjhsgfjsd25472354725472534hsdfjhsgfjsd’, null);
Execution of this changesets extremely slow:
DEBUG 11/28/18 3:15 PM: liquibase: 201811182215_RGS-28022.sql: 201811182215_RGS-28022.sql::8813::RGS-28022: Reading ChangeSet: 201811182215_RGS-28022.sql::8813::RGS-28022
DEBUG 11/28/18 3:54 PM: liquibase: 201811182215_RGS-28022.sql: 201811182215_RGS-28022.sql::8813::RGS-28022: Executing Statement: INSERT INTO Table1 (c1, c2, c3, Name, Active, Properties, Domain) VALUES
DEBUG 11/28/18 3:54 PM: liquibase: 201811182215_RGS-28022.sql: 201811182215_RGS-28022.sql::8813::RGS-28022: Executing EXECUTE database command: INSERT INTO Table1 (c1, c2, c3, Name, Active, Properties, Domain) VALUES
In this time we have 100% CPU load with java, and 1,2 - 1,6 Gb RAM used for this.
Is there ways exists for force liquibase use lover resources and execute such changesets faster? 3.5.3 and 3.5.5 versions affected