Bug 835912 - https://beaker.engineering.redhat.com/recipes/ is slow
Summary: https://beaker.engineering.redhat.com/recipes/ is slow
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: web UI
Version: 0.9
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
Assignee: Raymond Mancy
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-06-27 14:14 UTC by Ales Zelinka
Modified: 2019-05-22 13:42 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-07-20 00:39:11 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.