<div>
Have a look at the following tip: <br />
<br />
<a href="http://craiccomputing.blogspot.com/2011/02/always-index-columns-that-you-want-to.html" rel="ugc">http://craiccomputing.blogspot.com/2011/02/always-index-columns-that-you-want-to.html</a><br />
<br />
Gary
</div>


Have a look at the following tip:

http://craiccomputing.blogspot.com/2011/02/always-index-columns-that-you-want-to.html [http://craiccomputing.blogspot.com/2011/02/always-index-columns-that-you-want-to.html]

Gary

<div>
Hi Gary, sorry for late response. Quite busy recently.<br />
<br />
Could you please check the link? Can't access to it.
</div>


Hi Gary, sorry for late response. Quite busy recently.

Could you please check the link? Can't access to it.

<div>
<div class="content wysiwyg-content">
When I want to sort by multiple keys on mongodb , I got some problem , And can I fix it ??<br />
<br />
db.test.a.count()<br />
<br />
78150<br />
<br />
db.test.a.ensureIndex({a:1<wbr />,b:1,c:1,d<wbr />:1});<br />
<br />
db.test.a.find().sort({a:1<wbr />,b:1,c:1,d<wbr />:1});<br />
<br />
error: { &quot;$err&quot; : &quot;too much data for sort() with no index. add an index or speci fy a smaller limit&quot;, &quot;code&quot; : 10128 }
</div>
</div>


When I want to sort by multiple keys on mongodb , I got some problem , And can I fix it ??

db.test.a.count()

78150

db.test.a.ensureIndex({a:1,b:1,c:1,d:1});

db.test.a.find().sort({a:1,b:1,c:1,d:1});

error: { "$err" : "too much data for sort() with no index. add an index or speci fy a smaller limit", "code" : 10128 }

MongoDB question

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A NoSQL database provides a mechanism for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include: simplicity of design, simpler "horizontal" scaling to clusters of machines and finer control over availability. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are specified from those used by default in relational databases, making some operations faster in NoSQL. Sometimes the data structures used by NoSQL databases are also viewed as "more flexible" than relational database tables.