Import contributions (update existing) extremely slow
Overview
On a large database, importing updates of existing contributions is extremely slow (about 10 times slower than inserting new contributions).
This is new with 5.53 or 5.54.
Reproduction steps
Reproducing requires large database with many contributions. Therefore not yet reproducible on sandbox.
Current behaviour
Inserting new contributions works on this specific production environment at a rate of 140 contributions per minute.
Updating existing contributions is at an average of only 13 contributions per minute.
Expected behaviour
Previously, updating existing contributions was slightly faster than inserting new contributions.
Environment information
- Browser: _Firefox 105.0.3
- CiviCRM: _5.54.0 (was working well with 5.52.x)
- PHP: _7.4
- CMS: _Drupal 7.52
- Database: MariaDB 10.5.15
Comments
none