#7186 Need index on artifact_feed (project_id, pubdate) NEEDS ENSURE_INDEX

v1.2.0
closed
General
Cory Johns
2015-08-20
2014-02-18
No

While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate. The sort part isn't indexed.

Discussion

  • Dave Brondsema

    Dave Brondsema - 2014-02-18
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1 +1 @@
    -While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate.  The sort pat isn't indexed.
    +While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate.  The sort part isn't indexed.
    
    • status: in-progress --> code-review
     
  • Dave Brondsema

    Dave Brondsema - 2014-02-18

    db/7186

     
  • Cory Johns

    Cory Johns - 2014-02-19
    • QA: Cory Johns
     
  • Cory Johns

    Cory Johns - 2014-02-19

    Anonymous user caching was erroneously included in the commit.

     
  • Cory Johns

    Cory Johns - 2014-02-19
    • status: code-review --> closed
     
  • Cory Johns

    Cory Johns - 2014-02-19

    Removed extraneous change per discussion and merged.

     
  • Dave Brondsema

    Dave Brondsema - 2015-01-05
    • Milestone: unreleased --> asf_release_1.2.0
     

Log in to post a comment.