BugTrackerSet:+index consistently slower than 10 seconds

Bug #618375 reported by Robert Collins
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Robert Collins

Bug Description

https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1720G80

https://launchpad.net/bugs/bugtrackers/+index

DB id: 4351846
Branch: launchpad-rev-9766
Revno: 9766
SQL time: 4537 ms
Non-sql time: 7342 ms
Total time: 11879 ms
Statement Count: 938

Repeated SQL Statements top

Reps Total time Average time Saving Database id Statement
1 915 4354 4 4350 SQL-launchpad-main-slave SELECT COUNT(*) FROM BugWatch WHERE BugWatch.bugtracker = %s

description: updated
Changed in malone:
assignee: nobody → Robert Collins (lifeless)
Changed in malone:
status: Triaged → In Progress
Changed in malone:
status: In Progress → Fix Committed
tags: added: qa-ok
Changed in malone:
milestone: none → 10.10
Revision history for this message
Launchpad QA Bot (lpqabot) wrote : Bug fixed by a commit
tags: added: qa-needstesting
removed: qa-ok
tags: added: qa-ok
removed: qa-needstesting
Curtis Hovey (sinzui)
Changed in malone:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.