How can we improve count query execution time

[Rajesh Gupta]

I am using count query with some criteria on 945269 documents and I also used hint but this is taking long time.
Kindly suggest any other approach to solve it.

[Dominic Kumar]

Can you post the explain plan ?

On Wed, Oct 26, 2016 at 5:50 AM, Rajesh Gupta <rajeshgu...@gmail.com> wrote:

I am using count query with some criteria on 945269 documents and I also used hint but this is taking long time.
Kindly suggest any other approach to solve it.

--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
 
For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+unsubscribe@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/1cd623c5-c4a0-46e2-ad18-18570e2855d6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Thanks,
Dominic Kumar

713 376 6773

713 589 4766

Skype - dominicvivek06

.