Optimize Query Performance

Create Indexes to Support Queries

For commonly issued queries, create indexes. If a query searches multiple fields, create a 複合インデックス. Scanning an index is much faster than scanning a collection. The indexes structures are smaller than the documents reference, and store references in order.

db.posts.createIndex( { author_name : 1 } )

Indexes also improve efficiency on queries that routinely sort on a given field.

db.posts.createIndex( { timestamp : 1 } )

db.posts.find().sort( { timestamp : -1 } )

Because MongoDB can read indexes in both ascending and descending order, the direction of a single-key index does not matter.

Indexes support queries, update operations, and some phases of the 集計パイプライン.

BinData 型のインデックス キーは、次の場合、より効率的にインデックスに保存されます。

• バイナリ サブタイプ値が 0〜7 または 128〜135 の範囲にあり、かつ

• バイト配列の長さは、0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 12, 14, 16, 20, 24 または 32 です。

Limit the Number of Query Results to Reduce Network Demand

MongoDB cursors return results in groups of multiple documents. If you know the number of results you want, you can reduce the demand on network resources by issuing the limit() method.

This is typically used in conjunction with sort operations. For example, if you need only 10 results from your query to the posts collection, you would issue the following command:

db.posts.find().sort( { timestamp : -1 } ).limit(10)

For more information on limiting results, see limit()

Use Projections to Return Only Necessary Data

When you need only a subset of fields from documents, you can achieve better performance by returning only the fields you need:

For example, if in your query to the posts collection, you need only the timestamp, title, author, and abstract fields, you would issue the following command:

db.posts.find( {}, { timestamp : 1 , title : 1 , author : 1 , abstract : 1} ).sort( { timestamp : -1 } )

For more information on using projections, see クエリから返されるプロジェクト フィールド.

使用 $hint to Select a Particular Index

In most cases the クエリオプティマイザ selects the optimal index for a specific operation; however, you can force MongoDB to use a specific index using the hint() method. Use hint() to support performance testing, or on some queries where you must select a field or field included in several indexes.

Use the Increment Operator to Perform Operations Server-Side

Use MongoDB's $inc operator to increment or decrement values in documents. The operator increments the value of the field on the server side, as an alternative to selecting a document, making simple modifications in the client and then writing the entire document to the server. The $inc operator can also help avoid race conditions, which would result when two application instances queried for a document, manually incremented a field, and saved the entire document back at the same time.