- **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 [email protected] 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.
