Review main Abandoned

95354[TASK] Bulk insert functional test data sets

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

Commit message

Functional CSV data sets currently execute one INSERT statement for
every row. Large fixtures therefore spend most of their setup time on
database round trips.

Resolve column types once per table and retain the required JSON
conversion. Insert all rows through Connection::bulkInsert().
The connection automatically splits statements at the platform
parameter limit. Empty data sets and sequence resets keep their
existing behavior.

For RootlineUtilityTest with 743 fixture rows, runtime decreases by 28%
on PostgreSQL, 48% on SQLite, and 80% on MariaDB. A complete MariaDB CI
chunk passes with 2,073 tests and 12,044 assertions.

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, 18:27

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

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

    will be updates in another change