Review main Abandoned

95358[TASK] Bulk insert functional database snapshots

Wouter Wolters CR 0 V 0 Easy +27 −18 updated 09/04/26, 14:15

Commit message

Database snapshot restoration currently executes one INSERT statement
for every saved row. Snapshot-heavy test cases therefore spend much of
their setup time on database round trips.

Restore each table through Connection::bulkInsert(). The connection
preserves the existing type conversion and automatically chunks
statements at the database platform's parameter limit.

For the 173-test SlugLinkGeneratorTest on MariaDB, runtime decreases
from 6:06.929 to 1:59.403, saving 4:07.526 or 67.5%. The same test
passes on PostgreSQL in 1:03.907.

Review

  • Code review CR 0
  • Verified V 0
    • core-ci +1 CI

Files 2

Review log 23

  1. Wouter Wolters uploaded patch set 1 08/17/26, 19:01

  2. core-ci voted on patch set 1 V +1 08/17/26, 19:07 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/106837

  3. Wouter Wolters abandoned the change 09/04/26, 14:15

    will be updates in another change