Bug #3374

Large reports cause extremely slow requests

Added by Rein Henrichs almost 2 years ago. Updated over 1 year ago.

Status:Closed Start date:03/16/2010
Priority:High Due date:
Assignee:- % Done:

0%
Category:-
Target version:1.0
Keywords: Affected URL:
Branch: Affected Dashboard version:
Votes: 0

Description

As the YAML reports become larger, SQL queries on the reports table begin to take an unacceptable amount of time. Refactoring the reports table to move more data out of YAML will help mitigate this problem.

Related issues

related to Puppet Dashboard - Bug #3298: reports.report datatype leads to data loss Closed 02/25/2010

History

#1
Updated by Rein Henrichs almost 2 years ago

  • Status changed from Unreviewed to Accepted

#2
Updated by Rein Henrichs almost 2 years ago

  • Status changed from Accepted to In Topic Branch Pending Review

indexes on the reports table have mitigated this in most cases. Please let us know if there are further performance problems.

#3
Updated by Rein Henrichs over 1 year ago

  • Status changed from In Topic Branch Pending Review to Closed

Until our move to structured report data, which will happen after the release of Rowlf, the indexes added to the reports table should make most queries far more performant.

#4
Updated by Igal Koshevoy over 1 year ago

  • Target version set to 1.0

Also available in: Atom PDF