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() ) ) )}