[TYPO3-core] RFC #9797: Bug: waste of time in LIST module with LOISmode
Steffen Kamper
info at sk-typo3.de
Thu Nov 27 20:46:46 CET 2008
FYI: committed to trunk rev 4492
after my +1 by reading and testing.
vg Steffen
Franz Holzinger schrieb:
> This is an SVN patch request.
>
> Type: Bugfix
>
> Bugtracker references:
> http://bugs.typo3.org/view.php?id=9797
>
> Branches:
> TYPO3_4-2 & trunk
>
> Problem:
> When you want to use the mode to list the tables only in single table
> view (LOISmode), then big and slow SQL queries are unnecessarily still
> performed. This might cost some seconds of execution time.
>
> Solution:
> Do not perform this unnecessary SQL query over all records in LOIS mode,
> when only the count of records has been needed. The read in records are
> nowhere used.
>
> Notes:
> set page TSconfig:
> mod.web_list.listOnlyInSingleTableView = 1
>
>
> - Franz
>
More information about the TYPO3-team-core
mailing list