performance improvements when installing a large number of migration scripts

[frifle]

What version of Flyway are you using?

3.2.1

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)

Java API

What database are you using (type & version)?

oracle 11g and 12c

What operating system are you using?

unix

What did you do?

We are using flyway for an application which is life for some years now. Flyway is very reliable, thanks for that excellent framework! Recently we are running into performance problems because the number of scripts we are managing in our schema_versions-table has increased beyond 10.000.

The time flyway takes to migrate a single script has increased from some milliseconds to currently over a second. It seems that flyway per single migration step selects the full content of the schema-version table to calculate at client side its installation rank. Selecting and transporting the complete data of the versions table seems to be the cause for the increasing time per migration step.

I have written a testcase to demonstrate this, see this stackoverflow question.

What did you expect to see?

Migration of about 100 scripts should be (nearly) as fast as at beginning of our application life-cycle. Time to migrate our complete database should scale linear with total number of scripts.

What did you see instead?

Migration of about 100 scripts is getting slower. Time to migrate our complete database seems to increase exponentially with total number of scripts.