mongodb sort query taking more execution time

[sath...@amberconnect.com]

Hi,

Our MongoDB query is resulting fast but if add a sort attribute with that query .. it taking more time ... without sort it is fast ... any help?

eg: db.user.find().sort({ country: -1 });

--satheesh

[Babyduck]

Have you tried indexing the field?

Like:

db.user.createIndex({ country: -1 })

[sath...@amberconnect.com]

That field contains index already ... instead of country, we using DateTime as an attribute field...

[Wan Bachtiar]

instead of country, we using DateTime as an attribute field…

Hi Sateesh,

It’s not clear what you meant by `attribute` field, but you need to have the field your sorting with in an index.
Please see Use Indexes to Sort Query Results

Also, you can analyse how your query is performing by utilising cursor.explain().
See Explain Results for more information.

Regards,
Wan.

​