[TYPO3-core] RFC #9797: Bug: waste of time in LIST module with LOISmode

Dmitry Dulepov dmitry.dulepov at gmail.com
Thu Nov 27 15:38:14 CET 2008


Hi!

Franz Holzinger wrote:
> 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.

It does not make much difference on my localhost in the table with
25392 records but I give my +1 anyway. If the query can be avoided,
it must be avoided. Good patch, Franz!

-- 
Dmitry Dulepov
TYPO3 translations support
My TYPO3 book: http://www.packtpub.com/typo3-extension-development/book
In the blog:
http://typo3bloke.net/post-details/typo3_43_cache_and_memcached_fix_ready/


More information about the TYPO3-team-core mailing list