[TYPO3-core] RFC: #8515: Speed up tslib_cObj->getTreeList by caching its results

[Ingo Renner]

Dmitry Dulepov [typo3] wrote:

Hi

> It is not about hard disk space :) It is about how MySQl works. If you 
> get 100000 records or so in your cache table, it will be slow on SELECT 
> because indexes will not be used and full table scan will be done. It 
> will end up in many second delays while searching for cached data. May 
> be it is faster to perform recursive scans in this case.

do you have your (extension) records spread across 100000 sysfolders? ;)

> I want to clarify once again: I am not against the patch, I only have 
> small concerns that it may actually slow down the server under some 
> conditions.

sure, and I'm just trying to eliminate those concerns ;)


Ingo

-- 
Ingo Renner
TYPO3 Core Developer, Release Manager TYPO3 4.2