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

[Dmitry Dulepov [typo3]]

Hi!

Ingo Renner wrote:
>> 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 am talking about cache_* tables with that much records. I saw this in real life. Gives bad result for performance.

-- 
Dmitry Dulepov
TYPO3 Core team
More about TYPO3: http://typo3bloke.net/
Subscribe: http://typo3bloke.net/rss.xml