Bug #99505
closed
Useless SQL queries in extbase DataMapper
100%
Description
Whenever Extbase resembles domain models from the database (DataMapper thawProperties), it also tries to load related models even if no relation is assigned.
Example:
Model Book, property "reservingUser": stores UID of User record.
If no reservation is present, the field is "0" in the database.
Extbase still tries to:SELECT * from tx_..._user WHERE uid in (0)
All these kinds of queries return an empty result of course.
Fixing this can save you 25% of your DB requests, depending on the involved models.
Updated by Gerrit Code Review over 1 year ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77316
Updated by Markus Klein over 1 year ago
- Related to Bug #56442: Invalid FileReference used added
Updated by Gerrit Code Review over 1 year ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77316
Updated by Markus Klein about 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 006d6f4065c4fbd92de12cc330c1764b18eeb8a2.
Updated by Gerrit Code Review about 1 year ago
- Status changed from Resolved to Under Review
Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77582
Updated by Markus Klein about 1 year ago
- Status changed from Under Review to Resolved
Applied in changeset b10285e78473c5fb65a2e3dd60828f5950d9d9b5.