Thursday, 27 April 2017

slow performance mongoose query

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