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

[Duchesnes Grégory - Ilomedia]

Hi all and happy new year!

I have some performance problems on one of my sites and i activated mysql logs to check what was going on.
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.

Queries look like that, is this normal? :

...
		   25 Query	SELECT content FROM tx_extbase_cache_reflection WHERE identifier = 'ReflectionData_Simulatefe' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Web_Response' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Web_Response' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Simulatefe_Controller_UserController' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Simulatefe_Controller_UserController' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Simulatefe_Domain_Repository_UserRepository' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Simulatefe_Domain_Repository_UserRepository' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Controller_Arguments' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Controller_Arguments' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Controller_ArgumentsValidator' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_MVC_Controller_ArgumentsValidator' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Fluid_View_TemplateView' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Fluid_View_TemplateView' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_Query' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_Query' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_Typo3QuerySettings' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_Typo3QuerySettings' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
		   25 Query	SELECT treelist FROM cache_treelist WHERE md5hash = '2598fac88e9f22e6be19979f44961735' AND ( expires > 1357336098 OR expires = 0 ) LIMIT 1
		   25 Query	SELECT COUNT(*) FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_QueryResult' AND (crdate + lifetime >= 1357336098 OR lifetime = 0)
		   25 Query	SELECT content FROM tx_extbase_cache_object WHERE identifier = 'Tx_Extbase_Persistence_QueryResult' AND (crdate + lifetime >= 1357336098 OR lifetime = 0) LIMIT 1
...


Grégory Duchesnes - ilomedia
contact at ilomedia.net