Review main Abandoned

95353[TASK] Speed up functional data set imports

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

Commit message

CSV data set imports currently perform full Doctrine schema introspection for every imported table. PostgreSQL additionally queries several system catalog tables before synchronizing each auto-increment sequence.

Use TYPO3's cached schema information to obtain column types and identify the auto-increment column. Skip sequence handling for tables without such a column.

Pass the known column name to the sequence reset helper and use PG_GET_SERIAL_SEQUENCE() to synchronize PostgreSQL sequences in a single query. Retain the existing catalog lookup as a fallback for callers that do not provide column metadata.

In a complete PostgreSQL functional suite run with the same ten-way split as CI, aggregate runtime decreased from 2:26:36.598 to 2:14:04.534, saving 12:32.064 or 8.55%. The slowest chunk improved from 16:04.463 to 14:47.040, saving 8.03%. All 12,484 tests passed.

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, 17:00

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

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

    will be updates in another change