Project

General

Profile

Actions
Copy link

Bug #20887

closed

speed up function t3lib_BEfunc::selectVersionsOfRecord

Added by Rupert Germann over 15 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Rupert Germann
Category:
-
Target version:
-
Start date:
2009-08-14
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

problem:
when viewing the extended listview in the Backend, TYPO3 does 2 queries for each record to find out if it has versions. The first query fetches the currently displayed record again which is already present in the calling function.

solution:
traverse the current $row to function t3lib_BEfunc::selectVersionsOfRecord() and re-use it instead of fetching it from the DB

when displaying an extended list with 100 records this patch saves 100 queries from the ~800 which are executed, so don't expect to much from this patch ;-)
(issue imported from #M11722)

Files

Download all files
11722.diff (2.92 KB) 11722.diff Administrator Admin, 2009-08-14 17:08
11722_v3.diff (3.17 KB) 11722_v3.diff Administrator Admin, 2009-08-14 21:49

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Feature #20880: t3lib_BEfunc::selectVersionsOfRecord: Need a Hook for query-buildungClosedRupert Germann2009-08-14

Actions
Actions
Copy link

Also available in: Atom PDF