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

[Duchesnes Grégory - Ilomedia]

Hi Xavier,

this works on 4.6+ but not on 4.5. Maybe extbase object cache can not be switched off on 4.5...


Grégory Duchesnes - ilomedia
contact at ilomedia.net






Le 8 janv. 2013 à 08:33, Xavier Perseguers <xavier at typo3.org> a écrit :

> 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
> 
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english