| Summary: | recipes page is still slow | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Retired] Beaker | Reporter: | Dan Callaghan <dcallagh> | ||||
| Component: | general | Assignee: | beaker-dev-list | ||||
| Status: | CLOSED WONTFIX | QA Contact: | tools-bugs <tools-bugs> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 23 | CC: | jorris, mjia | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2020-10-21 14:14:12 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: | |||||
| Attachments: |
|
||||||
|
Description
Dan Callaghan
2016-09-07 04:41:20 UTC
Created attachment 1198755 [details]
Recipe fetch SQL Log
There's quite a lot of database queries being done on each request.
(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. |