Use a transaction PoDatabaseWriter to improve performance

Profiling results running time vendor/bin/drush si -y -v standard --account-mail=alex@example.com --account-name=admin --account-pass=PASSWORD --db-url=mysql://USER:PASSWORD@localhost/DB_NAME --locale=de

With MR

________________________________________________________
Executed in    7.29 secs    fish           external
   usr time    3.14 secs    0.21 millis    3.14 secs
   sys time    0.94 secs    3.19 millis    0.94 secs

Without MR

________________________________________________________
Executed in    9.45 secs    fish           external
   usr time    3.32 secs    0.25 millis    3.32 secs
   sys time    0.93 secs    2.56 millis    0.93 secs

The results are pretty consistent and will benefit sites with more translation files to import.

alexpott → changed the visibility of the branch 3520750-use-a-transaction to hidden.

This is great! This can save a lot of CI and CD time.

Snapshot from latest state of MR for safe usage with composer-patches.

Added 📌 Allow users to configure the locale chunk size in settings.php Active for @penyaskito's idead about making the chunk size configurable. I think @andypost's point about service injection is a much larger scope that does not really fit into a single issue and certainly should not hold this simple change up.

Thank you! as follow-up created let's get it in and speed-up 11.2)

Committed/pushed to 11.x and cherry-picked to 11.2.x, thanks!

catch → closed merge request !11927