Page MenuHomePhabricator

Slow query on contribution dashboard
Open, MediumPublic2 Estimated Story Points

Description

 SELECT  sum( total_amount ) as total_amount,
            count( c.id ) as total_count,
            currency
      FROM  civicrm_contribution c
INNER JOIN  civicrm_contact contact ON ( contact.id = c.contact_id )
     
     WHERE  contribution_status_id = 1 AND receive_date <= '20161214235959'
       AND  ( is_test = 0 OR is_test IS NULL )
       AND  contact.is_deleted = 0
  GROUP BY  currency

Event Timeline

Eileenmcnaughton updated the task description. (Show Details)
Eileenmcnaughton set the point value for this task to 2.
DStrine triaged this task as Medium priority.Feb 13 2017, 8:56 PM
Aklapper removed Eileenmcnaughton as the assignee of this task.Jun 19 2020, 4:22 PM

This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!

For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see https://phabricator.wikimedia.org/T228575#6237124 for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)