incubator-allura-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Brondsema" <brond...@users.sf.net>
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 sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/

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