Issue #7068 has been updated by James Turnbull. Status changed from Unreviewed to Accepted
---------------------------------------- Bug #7068: performance issue https://projects.puppetlabs.com/issues/7068 Author: Vincent Louviaux Status: Accepted Priority: Normal Assignee: Category: Target version: Keywords: performance Branch: Affected URL: Affected Dashboard version: 1.1.0 one query take always many seconds select on tables nodes or reports are very quick, I have notice this trouble only with this join. is an index missing or? <pre> Node Load (8157.7ms) SELECT `nodes`.* FROM `nodes` INNER JOIN `reports` ON reports.node_id = nodes.id WHERE ((reports.kind = 'apply' AND reports.status = 'failed') AND (`nodes`.`hidden` = 0)) GROUP BY nodes.id </pre> -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
