[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