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