In our use case I noticed a serious slowdown in schema migration after upgrading from 4.3 => 5.4.
For this I created a fix, that reads the tables in DatabaseInformationImpl for the whole namespace in one go, instead of one at a time. See attached patch too.
Schema migration with 5.4.10-final => 2 minutes 38 seconds
Schema migration with 5.4.11-final with cache: 1 minute 20 seconds
In our test case this concerns 559 classes that map to about 2400 tables. This is a default empty environment, depending on the usage exceeding 3000 tables is common.
For now I implemented the instance creation of {{DatabaseInformationCachedImpl}} directly in class: {{GroupedSchemaMigratorImp.java }}
Did not see added value in putting the instance creation of “{{DatabaseInformationCachedImpl}}“ to {{org.hibernate.tool.schema.internal}}.Helper
feel tree to change however. See also HHH-13844 |
|
