Project

General

Profile

Actions

Task #92071

closed

DatabaseRecordList: Drop unnecessary DB-Query for each table

Added by Daniel Windloff over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Category:
Code Cleanup
Target version:
-
Start date:
2020-08-22
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

For each TCA table a query to determine if a result exists is made.
It could have been some kind of performance optimization, but it results in an additional query for each table with records in place.

Such optimizations should be done in the getTable method by using the already existing query to count the number of records for one table. Therefore, the query to the get the result set is only executed if at minimum one record exists.

Actions #1

Updated by Gerrit Code Review over 3 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65410

Actions #2

Updated by Daniel Windloff over 3 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #3

Updated by Benni Mack over 3 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF