Seems like the bare `app_config_id` index comes from the `Artifact` class and
isn't something we can easily get rid of right now.
And fwiw, I'm pretty sure the order of fields in a query don't matter (since
its a dict). Just the order of fields in an index do.
---
** [tickets:#6379] Fix slow queries on the blog_post collection**
**Status:** closed
**Labels:** performance
**Created:** Wed Jun 19, 2013 07:43 PM UTC by Tim Van Steenburgh
**Last Updated:** Mon Jun 24, 2013 08:06 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.
