Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.1.0alpha1
-
None
-
Operating System: Ubuntu
PHP Version: (please be specific, like '4.4.3' or '5.1.5') : 5.2.6
Database and version: MySQL 5
Browser (and version):
Description
With eZ Publish 4.1alpha1 the list of Object state groups is loaded in every views of the content module. I think it is due to the use of eZContentObjectStateGroup::limitations() in kernel/content/module.php
This behaviour adds a new SQL query on all pages of a site which can probably be avoided by adding a cache updated when adding/editing a group.
Steps to reproduce
1. Install eZ Publish 4.1alpha1
2. Activate DebugOuput and SQLOutput
the "new"SQL query is done in all view of the content module, it looks like :
SELECT *
FROM ezcobj_state_group, ezcobj_state_group_language
WHERE ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id AND
ezcobj_state_group.language_mask & 3 > 0
AND
( ezcobj_state_group_language.language_id & ezcobj_state_group.language_mask > 0 AND
( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 1 )
+ ( ( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 2 ) )
<
( ezcobj_state_group_language.language_id & 1 )
+ ( ( ezcobj_state_group_language.language_id & 2 ) )
)