Bug 1373726 - recipes page is still slow
Summary: recipes page is still slow
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Beaker
Classification: Retired
Component: general
Version: 23
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified vote
Target Milestone: ---
Assignee: beaker-dev-list
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-07 04:41 UTC by Dan Callaghan
Modified: 2020-10-21 14:18 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-10-21 14:14:12 UTC

Attachments (Terms of Use)
Recipe fetch SQL Log (105.20 KB, text/plain)
2016-09-07 14:43 UTC, Jon Orris 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Description Dan Callaghan 2016-09-07 04:41:20 UTC 
In spite of bug 846199 being fixed in Beaker 23.0, the page is still unusably slow in large Beaker installations.

Running on my devel environment against a db dump from our production instance, the page takes 65 seconds to come back.
Comment 1 Jon Orris 2016-09-07 14:43:14 UTC 
Created attachment 1198755 [details]
Recipe fetch SQL Log

There's quite a lot of database queries being done on each request.
Comment 2 Jon Orris 2016-09-07 15:20:32 UTC 
(In reply to Jon Orris from comment #1)
> There's quite a lot of database queries being done on each request.

Additionally, this same set of queries is performed every 30 seconds on an open page with an unfinished recipe, due to the autofetch set in recipe.kid.

For the periodic refreshes, we should at least use If-Modified-Since headers, and ideally only request refreshes on sections that changed. That would require adding an 'updated_at' column to various tables that could be checked.
Note You need to log in before you can comment on or make changes to this bug.