Closed
Description
Description
Migrating a large number of realms, or subentities, becomes progressively slower.
With the optimizations available from #37991 we should be able to limit how much is accumulating in the persistence context and / or ensure queries are run in flush mode COMMIT to greatly reduce migration times.
Relates also to:
#37356
#38552
#34364
Discussion
No response
Motivation
To minimize downtime and to mostly avoid users needing to adjust the transaction timeout - however that will likely still be needed in some cases.
Details
No response