Often in templates, both a full count and a node retrieval with limit and offset are done for paginated results. However, the temporary tables used for permission checking - see eZContentObjectTreeNode::createPermissionCheckingSQL() - are not shared between these 2 but rebuild, although they're exactly the same. There should be implemented some mechanism to reuse them for the full duration of a page request, and dropping them only at the end.