Slow queries on main snaps listing page
Bug #1703400 reported by
Bret Barker
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Snap Store Server |
Fix Released
|
High
|
Maximiliano Bertacchini | ||
Bug Description
The main snap listing page https:/
https:/
| Changed in snapstore: | |
| status: | New → Confirmed |
| Changed in snapstore: | |
| assignee: | nobody → Daniel Manrique (roadmr) |
| importance: | Undecided → High |
Revision history for this message
| Daniel Manrique (roadmr) wrote | #1 |
| Changed in snapstore: | |
| assignee: | Daniel Manrique (roadmr) → Maximiliano Bertacchini (maxiberta) |
| status: | Confirmed → In Progress |
Revision history for this message
| Maximiliano Bertacchini (maxiberta) wrote | #2 |
Revision history for this message
| Maximiliano Bertacchini (maxiberta) wrote | #3 |
| Changed in snapstore: | |
| status: | In Progress → Fix Committed |
Revision history for this message
| Maximiliano Bertacchini (maxiberta) wrote | #4 |
| Changed in snapstore: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
The slowest query is getting scan_data_json which is known to be a large unwieldy field, there's a query that took about 1.5 seconds with that. However, then the next query doesn't start until about 1.8 seconds after the slow one finished. It sounds weird it would take that long to chew through the data, so I think this may have hit a generic I/O slowness error we've been seeing.
I'll check to see if we can optimize this somehow.