This landed with devel r11041. Tested on edge vs. production. There is a significant degradation in the query count - it may be that the pre-fetching is not working as expected (or it may be an unrelated change on edge, but unlikely). If it is related to this change it is approx. 4 queries per build when using the binary_only=False option :/. The page times are still comparable. Note: this does not effect the API, which has binary_only=True fixed (and hence uses the current implementation). Marking as qa-ok, but if we've time this or next cycle, it would be great to get this back down.
This landed with devel r11041. Tested on edge vs. production. There is a significant degradation in the query count - it may be that the pre-fetching is not working as expected (or it may be an unrelated change on edge, but unlikely). If it is related to this change it is approx. 4 queries per build when using the binary_only=False option :/. The page times are still comparable. Note: this does not effect the API, which has binary_only=True fixed (and hence uses the current implementation). Marking as qa-ok, but if we've time this or next cycle, it would be great to get this back down.
Edge (r11042): https:/ /edge.launchpad .net/~ubuntu- mozilla- daily/+ archive/ ppa/+builds? build_text= &build_ state=all& batch=50
At least 289 queries issued in 3.76 seconds
Production (10.05): https:/ /launchpad. net/~ubuntu- mozilla- daily/+ archive/ ppa/+builds? build_text= &build_ state=all& batch=50
At least 44 queries issued in 3.55 seconds