liquibase-redshift icon indicating copy to clipboard operation
liquibase-redshift copied to clipboard

improve performance of databasechangelog updates?

Open tooptoop4 opened this issue 7 months ago • 0 comments

if i have a sql changeset file with 600 different changesets and then add 601st changeset i notice a lot of individual UPDATE sqls (looks like 1 per changeset to update latest time for the hash) are running against the internal liquibase databasechangelog table (in redshift,) if each one takes 300ms then the time adds up. for redshift can these updates be batched up into 1 update?

tooptoop4 avatar Jul 02 '24 22:07 tooptoop4