[TYPO3-core] RFC #11764: speed up list module by improving internal handling of localisations

Rupert Germann rupi at gmx.li
Fri Aug 21 16:31:13 CEST 2009


Hi,

this is a SVN patch request.

Type: Bugfix

Bugtracker references:
http://bugs.typo3.org/view.php?id=11764

Branches: Trunk

Problem:
The handling of translations in the list module (localization view) is 
inefficient.
2 SQL queries will be executed to find existing localisations and for 
showing the localisation panel. Both queries are basically the same, 
only the selected fields are changed. Additionally the list module 
instantiates a new object of class.t3lib_transl8tools for each record 
which is shown in the list.
class t3lib_transl8tools is initiated in exactly the same way each time 
(no constructor or other changing vars)

Solution:
Make only one query to find localizations and re-use the result.
initialize class transl8tools only once in function start() in 
class.db_list.inc and re-use it.

Benchmarks:
time for displaying a list of 100 records (single table view, 
Localization view=1). Page has 2 alternative page languages

trunk = ~115ms
patched = ~97ms

measured in class.db_list.inc function generateList()

greets
rupert



"There shall be no new TYPO3 version delivering content slower than its 
predecessor!"


More information about the TYPO3-team-core mailing list