incubator-allura-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Brondsema" <>
Subject [allura:tickets] #6379 Fix slow queries on the blog_post collection
Date Mon, 24 Jun 2013 20:06:38 GMT
- **QA**: Dave Brondsema


** [tickets:#6379] Fix slow queries on the blog_post collection**

**Status:** code-review
**Labels:** performance 
**Created:** Wed Jun 19, 2013 07:43 PM UTC by Tim Van Steenburgh
**Last Updated:** Thu Jun 20, 2013 08:34 PM UTC
**Owner:** Tim Van Steenburgh

These were added in prod mongo directly:

db.blog_post.ensureIndex({state: 1, app_config_id: 1, timestamp: -1}, {background: true});
db.blog_post.ensureIndex({state: 1, neighborhood_id: 1, timestamp: -1}, {background: true});

Need to add them in the class definition. Consider switching the order of the fields in these
queries and removing the app_config_id-only index.


Sent from because is subscribed to

To unsubscribe from further messages, a project admin can change settings at
 Or, if this is a mailing list, you can unsubscribe from the mailing list.
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message