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

v1.2.0
closed
Dave Brondsema
performance (126) sf-1 (616)
General
Cory Johns
2015-08-20
2014-02-18
Dave Brondsema
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 - 2014-02-19
    • QA: Cory Johns
     

  • Cory Johns - 2014-02-19

    Anonymous user caching was erroneously included in the commit.

     

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

  • 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.