diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-10-09 15:29:05 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2015-10-23 14:46:01 +0100 |
| commit | 591c90a2ac4ea419a062bf19fffb0831d06786df (patch) | |
| tree | 54a6d3245cde45525a9a88fc18ccb73c301eb6ed /perllib/FixMyStreet/App/Controller/Status.pm | |
| parent | 97cd4dd5d39ee23a4c8f0863809e4230f954274a (diff) | |
Speed up admin front page.
* Don't show a categories summary unless asked via a link
* Don't needlessly join in questionnaire/update summaries
* Switch count(distinct()) to a subselect as it turns out
select count(*) from (select distinct(user_id) from problem) temp;
is a lot quicker than select count(distinct(user_id)) from problem;
Diffstat (limited to 'perllib/FixMyStreet/App/Controller/Status.pm')
0 files changed, 0 insertions, 0 deletions