Project

General

Profile

Actions

Task #55568

closed

BE: Only make SQL count calls on uid not *

Added by Benni Mack about 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2014-02-01
Due date:
% Done:

100%

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

Description

The Record List (list and page module) runs
over all TCA tables and checks if a table should
be listed.

The total query information is called for every table,
which is quite a lot. However, only the count number
on these TCA tables is important. That's why the call
to COUNT is rewritten to COUNT which speeds
up these SQL calls.


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #55891: Insert a CheckIfRecordExists in ListmoduleClosedStefan Froemken2014-02-11

Actions
Related to TYPO3 Core - Task #56167: Cleanup exec_SELECTcountRows() calls to NOT count *Closed2014-02-20

Actions
Actions #1

Updated by Gerrit Code Review about 10 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/27247

Actions #2

Updated by Benni Mack about 10 years ago

  • Status changed from Under Review to Rejected
Actions #3

Updated by Gerrit Code Review about 10 years ago

  • Status changed from Rejected 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/27554

Actions #4

Updated by Xavier Perseguers about 10 years ago

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

Bug reference has been changed in some patchset leading to forgetting to auto-close this ticket.

Actions #5

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF