Maniphest T168499

Add index 'name' to civicrm_campaign table
Closed, ResolvedPublic1 Estimated Story Points
Actions

Description

As I am joining on this field (which should be a suitable field for indexing) it needs an index.

Details

	Subject	Repo	Branch	Lines +/-
	Add index to civicrm_campaign.name	wikimedia/fundraising/crm	master	+12 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		None	T161757 EPIC: Add key silverpop data into Civi
		Resolved		Eileenmcnaughton	T161759 retrieve the contacts who have signed up for email without going through our donor system
		Resolved		Eileenmcnaughton	T161760 Reflect all unsubscribes via Silverpop in CiviCRM
		Resolved		Eileenmcnaughton	T168499 Add index 'name' to civicrm_campaign table

Event Timeline

Eileenmcnaughton created this task.Jun 21 2017, 6:33 AM

Change 360608 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Add index to civicrm_campaign.name

https://gerrit.wikimedia.org/r/360608

gerritbot added a project: Patch-For-Review.Jun 21 2017, 6:36 AM

• DStrine moved this task from Triage to Completed in Q4 2016-17 on the Fundraising-Backlog board.Jun 21 2017, 5:07 PM

Eileenmcnaughton moved this task from Backlog to Review on the Fundraising Sprint Kickstopper board.Jun 21 2017, 8:06 PM

• DStrine added a project: Fundraising Sprint Loose Lego Carpeting.Jun 21 2017, 8:17 PM

Eileenmcnaughton moved this task from Backlog to Review on the Fundraising Sprint Loose Lego Carpeting board.Jun 22 2017, 2:08 AM

Eileenmcnaughton moved this task from Review to Pending Deployment on the Fundraising Sprint Loose Lego Carpeting board.Jun 28 2017, 8:19 AM

Eileenmcnaughton moved this task from Pending Deployment to Review on the Fundraising Sprint Loose Lego Carpeting board.

Change 360608 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Add index to civicrm_campaign.name

https://gerrit.wikimedia.org/r/360608

Ejegg moved this task from Review to Pending Deployment on the Fundraising Sprint Loose Lego Carpeting board.Jul 5 2017, 7:49 PM

• DStrine added a project: Fundraising Sprint Murphy's Lawyer.Jul 5 2017, 8:23 PM

Eileenmcnaughton moved this task from Backlog to Done on the Fundraising Sprint Murphy's Lawyer board.Jul 6 2017, 4:46 AM

• DStrine moved this task from Completed in Q4 2016-17 to Current Sprint and Completed in Q1 2017-18 on the Fundraising-Backlog board.Jul 6 2017, 4:43 PM

Eileenmcnaughton closed this task as Resolved.Jul 11 2017, 4:35 AM

Eileenmcnaughton set the point value for this task to 1.Aug 29 2017, 7:54 PM