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

Hide/Unhide will cause heavy database traffic in cluster mode

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Medium Medium
    • Resolution: Obsolete
    • Affects Version/s: 3.10.1, 3.9.5, 4.0.1
    • Fix Version/s: Customer request
    • Labels:
      None
    • Environment:

      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.

        Issue Links

          Activity

          Hide
          ezrobot added a comment -

          This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          Show
          ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

            People

            • Assignee:
              unknown
              Reporter:
              Dirk Schmedding
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: