#107546Streamline `SchemaInformation` cache handling
Description
During introducing the native json field support the custom
internal `SchemaInformation` has been implemented [1], which
was required to provide a cache layer to reduce costs related
to database schema lookups in a handfull of places.
The cache layer has been changed from core cache to a dedicated
`database_schema` cache to use the VariableFrontend per default,
using `serialize/deserialize` under the hood [2].
Trying to replace costly database schema calls in TYPO3 [3]
revealed an issue caching Doctrine DBAL schema objects and
has been reverted [4].
Further investigation revealed, that we only need specific
subset of schema information in the several places of our
beloved CMS, nailed down to:
- list table names of a database connection
- list table column names for a database of a connection
- list table columns to get information required to make
decision how to process things in a handfull of places.
`SchemaInformation` was never ment to provide a complete
cached replacement for the database schema methods provided
by `AbstractSchemaManager` from Doctrine DBAL, the goal
was to only have necessary data cached to reduce database
queries to slow schema information tables.
[1] https://review.typo3.org/c/Packages/TYPO3.CMS/+/76553
2 https://review.typo3.org/c/Packages/TYPO3.CMS/+/79148
3 https://review.typo3.org/c/Packages/TYPO3.CMS/+/90562
4 https://review.typo3.org/c/Packages/TYPO3.CMS/+/90588
Reviews 5
- main 90566[WIP][TASK] Warmup database cache listening to `CacheWarmupEvent`
- 13.4 90950[TASK] Use `runtime` cache in `SchemaInformation` as 2nd level cache
- main 90563[TASK] Use `runtime` cache in `SchemaInformation` as 2nd level cache
- 13.4 90947[TASK] Streamline `SchemaInformation` cache handling
- main 90786[TASK] Streamline `SchemaInformation` cache handling
Related issues 7
- Feature #99062Native JSON field support in Doctrine DBAL
- Bug #100925Improve database schema cache
- Task #107390Avoid costly database schema queries and class state
- Bug #107406Revert "Avoid costly database schema queries and class state"
- Task #107610Introduce `runtime` cache to `SchemaInformation`
- Task #107612Warmup database cache listening to `CacheWarmupEvent`
- Bug #108615DatabaseRowsUpdateWizard is so slow
History 615
-
Stefan Bürk changed Related to #107406 Related to #107390 Related to #100925 Related to #99062 <span data-processor="relativetime" data-value="2025-09-26T11:12:55+00:00" > 09/26/25, 11:12 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 90786 status
NewUnder Review <span data-processor="relativetime" data-value="2025-09-26T11:20:06+00:00" > 09/26/25, 11:20 </span> -
Gerrit Code Review pushed patch set 4 for main to change 90786 <span data-processor="relativetime" data-value="2025-09-26T11:46:01+00:00" > 09/26/25, 11:46 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 90786 <span data-processor="relativetime" data-value="2025-09-26T12:20:09+00:00" > 09/26/25, 12:20 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 90786 <span data-processor="relativetime" data-value="2025-09-26T12:32:50+00:00" > 09/26/25, 12:32 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 90786 <span data-processor="relativetime" data-value="2025-10-01T06:50:35+00:00" > 10/01/25, 06:50 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 90786 <span data-processor="relativetime" data-value="2025-10-01T07:51:11+00:00" > 10/01/25, 07:51 </span>
-
Stefan Bürk changed Related to #107610 <span data-processor="relativetime" data-value="2025-10-06T14:10:38+00:00" > 10/06/25, 14:10 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 90786 <span data-processor="relativetime" data-value="2025-10-06T14:11:53+00:00" > 10/06/25, 14:11 </span>
-
Stefan Bürk changed Related to #107612 <span data-processor="relativetime" data-value="2025-10-06T14:26:54+00:00" > 10/06/25, 14:26 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 90786 <span data-processor="relativetime" data-value="2025-10-07T08:13:28+00:00" > 10/07/25, 08:13 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 90947 <span data-processor="relativetime" data-value="2025-10-07T13:02:36+00:00" > 10/07/25, 13:02 </span>
-
Stefan Bürk commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-10-07T13:25:08+00:00" > 10/07/25, 13:25 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T13:04:39+00:00" > 12/02/25, 13:04 </span> -
Stefan Bürk changed Related to #108615 <span data-processor="relativetime" data-value="2026-01-10T22:35:45+00:00" > 01/10/26, 22:35 </span>
Applied in changeset commit:b1fe08edae0e62d65dc94e0f4722d547516fdf1f.