Page MenuHomePhabricator

[EPIC] Lybunt report could be faster
Closed, ResolvedPublic

Description

I did a little digging on the Lynbunt query & found a small change to the sql changed the query time substantially.

Query time - as is
WHERE YEAR(last_donation_date) = 2013
503 rows in set (2 min 9.19 sec)

WHERE last_donation_date BETWEEN '2013-01-01' AND '2013-12-31 23:59:59'
503 rows in set (25.67 sec)

Event Timeline

Eileenmcnaughton raised the priority of this task from to Needs Triage.
Eileenmcnaughton updated the task description. (Show Details)
Eileenmcnaughton subscribed.
atgo renamed this task from Lynbunt report could be faster to Lybunt report could be faster.Jan 19 2016, 8:07 PM
DStrine renamed this task from Lybunt report could be faster to [EPIC] Lybunt report could be faster.Jan 19 2016, 8:08 PM
DStrine added a project: Epic.
DStrine moved this task from Triage to Sprint +1 on the Fundraising-Backlog board.
DStrine moved this task from Sprint +1 to Sprint +3 on the Fundraising-Backlog board.

@DStrine I think we can close this based on the email discussion