Opened 14 years ago
Last modified 14 years ago
#142 closed enhancement
Make sure we're using 100% efficient queries / indexes — at Initial Version
| Reported by: | Christopher Allan Webber | Owned by: | Christopher Allan Webber |
|---|---|---|---|
| Priority: | trivial | Milestone: | |
| Component: | programming | Keywords: | post-sql |
| Cc: | Parent Tickets: |
Description
Every query we use should be able to efficiently use an index, yet
at the same time, we shouldn't create superflous indexes.
Related:
- `http://kylebanker.com/blog/2010/09/21/the-joy-of-mongodb-indexes/ <http://kylebanker.com/blog/2010/09/21/the-joy-of-mongodb-indexes/>`_
- `http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ <http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ>`_
- `http://www.mongodb.org/display/DOCS/Indexes <http://www.mongodb.org/display/DOCS/Indexes>`_
Especially, we should play with using explain:
`http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ#IndexingAdviceandFAQ-Use{{explain <http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ#IndexingAdviceandFAQ-Use%7B%7Bexplain>`_}}.
Assigning to myself, but feel free to claim this if you're excited
about investigating.
Note:
See TracTickets
for help on using tickets.
