D-Programming-Language/d-programming-language.org — comment on commit cd1b918a46b563e2bbb192531b90710e849ad297
File:  line 0
By braddr:

This change set concerns me quite a bit. You've introduced a bunch of heavy queries that only want counts and instead are retrieving thousands of bugs just to throw it all away. Good concept, expensive implementation. These two report queries will give you the values you want very cheaply:

bug status and counts:
http://d.puremagic.com/issues/report.cgi?y_axis_field=bug_status&query_format=report-table&product=D&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&format=table&action=wrap&ctype=csv

and severities and counts:
http://d.puremagic.com/issues/report.cgi?y_axis_field=bug_severity&query_format=report-table&product=D&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_severity=regression&bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&bug_severity=enhancement&format=table&action=wrap&ctype=csv