Project

General

Profile

Actions

Task #55568

closed

BE: Only make SQL count calls on uid not *

Added by Benni Mack almost 11 years ago. Updated about 7 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

Also available in: Atom PDF