Project

General

Profile

Actions

Feature #186

closed

UI Slows down when reports are not purged form DB.

Added by Telmo X almost 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

If you don't purged the reports from your database the lookup queries for the last report of a hosts start slowing down due to the way ActiveRecord queries for it:
Host.reports.last will generate the following SQL statement:

Report Load (1611.5ms) SELECT * FROM `reports` WHERE (`reports`.host_id = 19) ORDER BY reports.id DESC LIMIT 1

By changing that query to Host.find(host.id).reports.maximum('id')) we make a more efficient query improving the response.

Report Load (3.2ms) SELECT * FROM `reports` WHERE (`reports`.`id` = 85955)

Patch attached


Files

0001-report-lookup-change.patch 0001-report-lookup-change.patch 3.99 KB change Host.reports.last to Host.find(host.id).reports.maximun('id') Telmo X, 03/22/2010 04:17 PM
Actions #1

Updated by Telmo X almost 14 years ago

  • Status changed from New to Ready For Testing
Actions #2

Updated by Ohad Levy almost 14 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF