[TYPO3-english] huge amount of queries to tx_extbase_cache_object table

[Xavier Perseguers]

Hi,

Seems your reference is incorrect. This works:

$TYPO3_CONF_VARS['SYS']['caching']['cacheConfigurations']['extbase_object']['backend']
= 't3lib_cache_backend_NullBackend';

Kind regards
Xavier

Duchesnes Grégory - Ilomedia wrote:
> Hi,
> 
> i've tried to disable extbase object and reflection cache by adding the following lines to my ext_localconf.php file. This worked for reflection cache but my settings for object cache are ignored, therefore i still have 233 queries in my log.
> I've tried APC backend, this increases performances a bit but does not reduce the number of queries.
> And yes, Caching framework is activated.
> 
> Seems like the backend for extbase cache object is always ignored.
> 
> 
> //$GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_object']['backend'] = 't3lib_cache_backend_ApcBackend';
> //$GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_reflection']['backend'] = 't3lib_cache_backend_ApcBackend';
> $GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_object']['backend'] = 't3lib_cache_backend_NullBackend';
> $GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_reflection']['backend'] = 't3lib_cache_backend_NullBackend';
> 
> unset($GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_object']['options']['cacheTable']);
> unset($GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_object']['options']['tagsTable']);
> unset($GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_reflection']['options']['cacheTable']);
> unset($GLOBALS['TYPO3_CONF_VARS']['SYS']['caching']['cacheConfigurations']['cache_extbase_reflection']['options']['tagsTable']);
> 
> 
> 
> Grégory Duchesnes - ilomedia
> contact at ilomedia.net
> 
> 
> 
> 
> 
> 
> Le 5 janv. 2013 à 21:27, Steffen Müller <typo3 at t3node.com> a écrit :
> 
>> Hi.
>>
>> Am 04.01.2013 22:50, schrieb Duchesnes Grégory - Ilomedia:
>>> To my great surprise i have more than 200 queries to the tx_extbase_cache_object table every time i load a page, it seems insane to me (and my server too). I use TYPO 4.5.
>>>
>> Try to use apc as caching backend instead of Db for tx_extbase_cache_object:
>> $TYPO3_CONF_VARS['SYS']['caching']['cacheConfigurations']['tx_extbase_cache_object']['backend']
>> = 't3lib_cache_backend_ApcBackend';
>>
>> In 4.5 you possibly have to turn on the caching framework if not yet done:
>> $TYPO3_CONF_VARS['SYS']['useCachingFramework'] = true
>> (should be removed in >= 4.6)
>>
>> Do not use apc as caching backend if you work in shared hosting
>> environments:
>> http://wiki.typo3.org/Caching_framework#t3lib_cache_backend_ApcBackend
>>
>> To be honest, I can't remember if I truly have proved the performance
>> impact myself. And I forgot where this suggestion came from.
>>
>>
>>
>> -- 
>> cheers,
>> Steffen
>>
>> TYPO3 Blog: http://www.t3node.com/
>> Twitter: @t3node - http://twitter.com/t3node
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> 

-- 
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org