Page MenuHomePhabricator

Slow query on live
Open, MediumPublic

Description

This query caused an issue (reported by @Jgreen )

user/215 */

CREATE TEMPORARY TABLE IF NOT EXISTS contribution_search_scredit_combined AS
   SELECT con.id as id, con.contact_id, cso.id as filter_id, NULL as scredit_id
     FROM civicrm_contribution con
LEFT JOIN civicrm_contribution_soft cso ON con.id = cso.contribution_id
 GROUP BY id, contact_id, scredit_id, cso.id
UNION ALL
   SELECT scredit.contribution_id as id, scredit.contact_id, scredit.id as filter_id, scredit.id as scredit_id
     FROM civicrm_contribution_soft as scredit;

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 19 2017, 1:05 AM
DStrine triaged this task as Medium priority.Jul 19 2017, 8:03 PM
Aklapper removed Eileenmcnaughton as the assignee of this task.Jun 19 2020, 4:20 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!)