Apache Allura™ / Tickets / #6226 Add project

#6226 Add project_id indexes

Milestone: v1.0.0

Status: closed

Owner: Cory Johns

Labels: performance (126) sf-1 (616)

Component: General

Reviewer: Dave Brondsema

Updated: 2015-08-20

Created: 2013-05-09

Creator: Dave Brondsema

Private: No

backup & removal scripts (internal to SourceForge at the moment) rely on querying collections by project_id if it has that in its ming schema. ShortlinkDoc and Notification have such, but they don't have indexes on project_id so the queries are extremely slow. We should add indexes for them.

Discussion

Cory Johns - 2013-05-17

status: open --> in-progress

assigned_to: Cory Johns

Size: --> 1

Milestone: forge-may-31 --> forge-may-17
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cory Johns - 2013-05-17

status: in-progress --> code-review
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cory Johns - 2013-05-17

allura:cj/6226

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2013-05-17

Milestone: forge-may-17 --> forge-may-31
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2013-05-20

status: code-review --> closed

QA: Dave Brondsema
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Apache Allura™

Forge software for hosting software projects

Milestone

Searches

Help

#6226 Add project_id indexes

Discussion