Mongodb find query running long time

Question

I am using mongodb latest version 3.4.10. i have collection name called transaction with 14000 records. the below query i ran it taking to complete 10sec.

command : db.transaction.find({mcCreatedTime : { $gte:ISODate("2017-10-01T00:00:00.000Z"), $lte:ISODate("2017-11-02T23:59:59.000Z")}})

It will return expected record with taking long time around 10 sec. I need to complete the query within msec.

I am using windows 8.1 and 4GB of RAM and 500GB hard disk.

score 0 · Answer 1 · answered Nov 08 '17 at 08:34

0

Try creating an index as:

db.transaction.createIndex({mcCreatedTime:1}, {background:true})

You need to take a look at explain to check why your query is slow.

answered Nov 08 '17 at 08:34

Atish

4,277
2
24
32

i have created index. but no luck. it's took 10sec to complete – K.Boopathi 17 Nov 08 '17 at 08:41
how much data you have? What does the explain command return? – Atish Nov 08 '17 at 08:42
the query is return correct output 6301 records . in my transaction collection it have 14000 records is there. – K.Boopathi 17 Nov 08 '17 at 08:51
Explain look like the query using IXSCAN .."executionStats" : { "executionSuccess" : true, "nReturned" : 6301, "executionTimeMillis" : 15, "totalKeysExamined" : 6301, "totalDocsExamined" : 6301, – K.Boopathi 17 Nov 08 '17 at 08:54
Your query takes only 15ms to execute in DB to execute :) – Atish Nov 08 '17 at 08:57
Ohh. i am running a query in robomongo. – K.Boopathi 17 Nov 08 '17 at 08:59
Maybe it look like robomongo issue? – K.Boopathi 17 Nov 08 '17 at 09:04
I don't know , why robomongo takes more time?? – K.Boopathi 17 Nov 08 '17 at 09:19

score 0 · Answer 2 · answered Nov 08 '17 at 08:36

0

The best way to get faster query results in a database management system is to build indexes.

Try creating an index on mcCreatedTime field to make it return results faster.

Ascending order: db.transaction.createIndex({'mcCreatedTime':1}) should be able to create the required index.

Mongo DB Index Creation

answered Nov 08 '17 at 08:36

pRmdk

151
1
10

Index created. but the query is result is slow – K.Boopathi 17 Nov 08 '17 at 08:52
@K.Boopathi17 can you check if you have implemented both ascending and descending indexes on date column, as both are required for faster results when doing sorting or range search. https://stackoverflow.com/a/10330373/1889046 – pRmdk Nov 08 '17 at 09:59

Mongodb find query running long time

2 Answers2