my application runs two similar querys:
{ id_test: 201,
total_value: { '$gte': 0 },
status: { '$nin': [ 'ABC', 'CBD', 'AFG' ] },
endos: { '$in': [ null, false ] } }
{ id_test: 201,
status: { '$nin': [ 'ABC', 'CBD', 'AFG' ] },
endos: { '$ne': null } }
The first one returns in 160 ~ 180 ms, but the second one in 12000 ~18000 ms.
I already try to use .limit(100) and .lean(true), but the performance continues the same.
How can i improve the speed of the second one?
via eduardo Uchida
No comments:
Post a Comment