Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 835912

Summary: https://beaker.engineering.redhat.com/recipes/ is slow
Product: [Retired] Beaker Reporter: Ales Zelinka <azelinka>
Component: web UIAssignee: Raymond Mancy <rmancy>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 0.9CC: bpeck, dcallagh, ebaak, rmancy, stl
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-07-20 00:39:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Ales Zelinka 2012-06-27 14:14:09 UTC 
Description of problem:
https://beaker.engineering.redhat.com/recipes/ loads veery slowly. Probably because the default filter (none) takes too much time to process. Any subsequent searches with custom filters are much quicker.

Please change the default settings or disable the actual search and only display filter setting after initial page load.
 
Version-Release number of selected component (if applicable):
0.9
Comment 1 Bill Peck 2012-06-28 19:54:57 UTC 
Ray, Any idea whats going on here?
Comment 2 Raymond Mancy 2012-06-29 13:03:51 UTC 
Recipes index has always been noticably slow.

Ales is right, in that the default query is very slow. The reason for this is because of it's ORDER BY combined with all the column data it eagerloads.

Playing around in the mysql shell, I was able to reduce the query time by half by reducing it the result set to what we need in the recipe grid and are currently not lazyloading.
Comment 3 Raymond Mancy 2012-07-10 06:26:35 UTC 
http://gerrit.beaker-project.org/#/c/1194/
Comment 6 Ales Zelinka 2012-07-16 15:51:53 UTC 
Well, the whole beaker-stage is slow so it's kinda hard to verify the fix :-).
But the /recipes/ page isn't slower than the rest of stage => fix verified. Thanks.
Comment 7 Dan Callaghan 2012-07-20 00:39:11 UTC 
Beaker 0.9.1 has been released.