#014227: Languages are loaded from database in all pages

Description:

By enabling the DebugOutput and the SQLOutput you can see the following query in all pages of a site (except on / with eZ Publish 4.0.1 ?)


SELECT id, name, locale, disabled
                    FROM   ezcontent_language
ORDER BY name ASC

It would be nice to cache the result of this query in a file so that it won't be done again and again. It seems that this query is generated by the call to eZContentLanguage::fetchLimitationList() by the permission system.


Environment:

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):


- Attachments

No attachments for this issue.


- Comments

Patch attempt #1

#262100 by Jérôme Renard on June 29th, 2009 [Permanent Link]
- Attachments: » bug14227.diff

Fixed in trunk, rev. 23773

#262177 by Jérôme Renard on July 2nd, 2009 [Permanent Link]

- History
Properties
Type Enhancement
Priority Medium
Components Caching
Content (images, XML, PDF, RSS, etc.)
Language
Affects 4.0.1 - 4.0.1release
4.1.0alpha1
Fix Version 4.2.0alpha1
Reporter Damien Pobel
Responsible Jérôme Renard
Status 0 Code Review
Resolution Implemented
Created January 5th, 2009
Updated July 2nd, 2009
Resolved July 2nd, 2009
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #019127
  DB Deadlocks on ezcontentobject_tree when updating subnode