[TYPO3-dev] performace of cachingframework

[Bjoern Pedersen]

Am 18.02.2011 10:47, schrieb Peter Russ:
> --- Original Nachricht ---
> Absender:   Bjoern Pedersen
> Datum:       18.02.2011 09:05:
>> Am 17.02.2011 22:50, schrieb Christian Kuhn:
>>> Hey,
>>>
>>> On 02/17/2011 05:11 PM, Bjoern Pedersen wrote:
>>>
>>>> SELECT identifier FROM cachingframework_cache_hash WHERE crdate +
>>>> lifetime<  1297803600 AND lifetime>  0;
>>> ...
>>>
>>> Those queries are only fired by the garbage collection task, they are no
>>> usual production queries from frontend?
>>>
>>> Regards
>>> Christian
>> Yes, that is correct. For normal cache retrieval the indentifier serves
>> as key.
>>
>> I will see wether I can create a patch.
> 
> NO this it NOT correct. The caching framework will check on every
> request ->has($key) if the cached content is "alive" :-(
> So this patch is even more important on production.
> 
> Peter.
> 
Well, on production the key is used and normally will return just 1 or
very few records where the scan for "is alive" has to be done. So there
the impact is rather low. But of course I will consider this in my patch.

Björn