Issue #4603 has been updated by Daniel Pittman. Status changed from Accepted to Closed
The majority of issues from this ticket have been addressed; what remains is, essentially, speculation about changes that might address (unstated) performance issues. We are going to go ahead and call out the specific issues elsewhere, as required. ---------------------------------------- Bug #4603: Improve performance https://projects.puppetlabs.com/issues/4603 Author: Igal Koshevoy Status: Closed Priority: Normal Assignee: Category: Target version: Keywords: Branch: Affected URL: Affected Dashboard version: Poor performance is annoying user and preventing larger sites from adopting the Puppet Dashboard. This is a meta-ticket describing Things to consider fixing: 1. Move the Report#report serialized blob into a separate table so that queries on the Report objects are faster. 2. Denormalize all the parts of the Report#report that are used by the show and index pages into the Report object, to avoid having to fetch and deserialize the raw data unless you're actually showing that report. 3. Rework the queries that power the various listing pages, these are fetching data for multiple graphs and the node listings at the same time in such a way that they retrieve huge amounts of data that they don't need. Consider making them tight, separate queries. 4. Refactor some of the very expensive queries, such as the ones producing the run-failure graph. Also refactor the arguments passed to these methods, like Status::by_interval only needs a list of node ids, yet is called with a scope of nodes and all the reports in the database. 5. Analyze queries and add indexes as needed. 6. And other unknown unknowns. The "query-trace" plugin can be a big help if used in development mode to find the queries, which we can then refactor. -- 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.
