#6208 add unique index on wiki title

v1.0.0
closed
Dave Brondsema
performance (126) sf-1 (616)
General
Cory Johns
2015-08-20
2013-05-07
Dave Brondsema
No

Wiki artifacts don't have any indexes on them (just the ones they inherit from Artifact). So a wiki tool with many pages will require scanning through all of them. We should have an index on (app_config_id, title), and might as well make it unique.

Discussion

  • Dave Brondsema

    Dave Brondsema - 2013-05-08
    • status: open --> in-progress
    • assigned_to: Dave Brondsema
     

  • Dave Brondsema

    Dave Brondsema - 2013-05-08

    https://trac.sdot.me/trac/siteops/ticket/53681 to run it on SF

    Need to make Ming default to background:true for index auto-creation (in ming/metadata.py +310)

     

  • Dave Brondsema

    Dave Brondsema - 2013-05-16
    • status: in-progress --> code-review
     

  • Dave Brondsema

    Dave Brondsema - 2013-05-16

    merciless:db/6208, allura:db/6208

    • Test: switch to & activate the new branch of ming first. Then switch to the allura branch, and visit any page. Run db.page.getIndexes() and see that background:true is recorded
    • Need to merge ming, cut a release, and bump the version in allura as part of the allura merge.
     

  • Cory Johns - 2013-05-17
    • QA: Cory Johns
     

  • Cory Johns - 2013-05-17

    The changes for this ticket are good, but there have been 24 other commits to Ming since the version we're using (though mostly to MIM), so it warrants some additional testing.

     

  • Dave Brondsema

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

  • Cory Johns - 2013-05-23
    • status: code-review --> closed
     

Log in to post a comment.