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

[Duchesnes Grégory - Ilomedia]

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