There's some rake tasks, and other things, suggested here: https://github.com/puppetlabs/puppet-dashboard
On Mon, Apr 11, 2011 at 5:29 AM, Vincent <[email protected]> wrote: > Hello, > > since the last upgrade to V1.1.0 > The dashboard is very slow > > I notice this slow queries in the log : > > Node Load (14178.9ms) 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 > Node Load (13149.9ms) 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 > > > How can i optimize the DB ? > > Vincent > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" 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-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Puppet Users" 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-users?hl=en.
