Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-13837

Hide/Unhide will cause heavy database traffic in cluster mode

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Medium Medium
    • Customer request
    • 3.10.1, 3.9.5, 4.0.1
    • None
    • Operating System:
      PHP Version: (please be specific, like '4.4.3' or '5.1.5')
      Database and version:
      Browser (and version):

    Description

      On hide/unhide the cache of the whole subtree will be expired.

      On a setup with 20 siteaccesses and 50 nodes in the subtree at least 1000 files will be expired. At a cluster enviroment this means 1000 SQLs on one table. This will cause the heavy load.

      On hide/unhide eZContentObjectTreeNode::clearViewCacheForSubtree()
      is called with the current node to expire the complete subtree.
      After some nested function calls in eZContentCacheManager
      eZDBFileHandler takes place and will delete all files of each node of the subtree which means at least one per siteaccess.

      Attachments

        Activity

          People

            unknown unknown
            dis dis
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: