#6226 Add project_id indexes

asf_release_1.0.0
closed
Cory Johns
General
2013-05-20
2013-05-09
Dave Brondsema
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
    Cory Johns
    2013-05-17

    • status: open --> in-progress
    • assigned_to: Cory Johns
    • Size: --> 1
    • Milestone: forge-may-31 --> forge-may-17
     
  • Cory Johns
    Cory Johns
    2013-05-17

    • status: in-progress --> code-review
     
  • Cory Johns
    Cory Johns
    2013-05-17

    allura:cj/6226

     
  • Dave Brondsema
    Dave Brondsema
    2013-05-17

    • Milestone: forge-may-17 --> forge-may-31
     
  • Dave Brondsema
    Dave Brondsema
    2013-05-20

    • status: code-review --> closed
    • QA: Dave Brondsema