https://bugzilla.wikimedia.org/show_bug.cgi?id=24455

           Summary: Show number of revs with each status on the status
                    page
           Product: MediaWiki extensions
           Version: any
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: CodeReview
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected]


Be useful to have the information in easy view. Simple queries as below:

<RoanKattouw> On the toolserver: 6 rows in set (6.48 sec)
<snip>
<RoanKattouw> It's a second faster on the cluster
<Reedy> That it?
<RoanKattouw> But that's still 5.5s
<Reedy> Yeah
<RoanKattouw> == too slow

mysql> SELECT cr_status, COUNT(*) FROM code_rev GROUP BY cr_status;
+-----------+----------+
| cr_status | COUNT(*) |
+-----------+----------+
| new       |    32444 | 
| fixme     |       65 | 
| reverted  |      615 | 
| resolved  |     1118 | 
| ok        |    32704 | 
| deferred  |    11016 | 
+-----------+----------+
6 rows in set (5.47 sec)

Tracking table is the alternative.

Also, any queries sorting/similar on cr_status are unindexed...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to