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

dashboard generate very slow queries

    XMLWordPrintable

    Details

      Description

      Hi

      the dashboard generate some slow queries:
      in the tpl dashbard.tpl

      {def $all_latest_content = fetch( 'content', 'tree', hash( 'parent_node_id', ezini( 'NodeSettings', 'RootNode', 'content.ini' ), 'limit', $block.number_of_items, 'sort_by', array( 'published', false() ) ) )}

      With the default settings, (on node 2 ) the querie will be very slow.
      -> mysql will parse all object just to get the last 10 items.

      Adding a new attribute filter on the modified/published date will fix it.
      Something like

      {def $dateEnd=sub(currentdate(),5184000)} {def $all_latest_content = fetch( 'content', 'tree', hash( 'parent_node_id', ezini( 'NodeSettings', 'RootNode', 'content.ini' ), 'limit', $block.number_of_items, 'attribute_filter',array( array('published','>=',$dateEnd) ), 'sort_by', array( 'published', false() ) ) )}

        Attachments

          Activity

            People

            Assignee:
            andre1 André R
            Reporter:
            scouzinier Stéphane Couzinier
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: