Project

General

Profile

Actions
Copy link

Bug #1007

closed

Foreman takes to long when searching for reports

Added by Corey Osman almost 13 years ago. Updated almost 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

This seems to be a problem with environments having a large number of reports (15000+ reports). The query can take up to 2 minutes to return.

Discussion here:
http://groups.google.com/group/foreman-users/browse_thread/thread/3afc1bebcbe7b682?hl=en

A simple query such as:

https://foreman/reports?search=FQDN

Actions
Copy link
 #1

Updated by Ohad Levy almost 13 years ago

  • Status changed from New to Need more information

when using a free text search (like in your example), foreman would search across all report attributes for a string called "fqdn", you really want to use the more specific search in this case, for example:

foreman/reports?search='host = fqdn'

in order to track the problem around large data set, it would be very helpful to get a debug output of the real sql queries.

Actions
Copy link
 #2

Updated by Corey Osman almost 13 years ago

yep that worked. Please close

Actions
Copy link
 #3

Updated by Ohad Levy almost 13 years ago

  • Status changed from Need more information to Closed
Actions
Copy link

Also available in: Atom PDF