79701631

Date: 2025-07-15 06:12:45
Score: 1
Natty:
Report link

There can be many reasons for being two times slower in dev vs. prod. Maybe you have other workloads in prod, so fewer documents remain in cache for this query.

Running with explain("executeStats") can help compare the work done and the time.

Note that if you can group before lookup (usually possible with many-to-one relationships, as you can group on the key, it will be faster in both cases

Reasons:
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: FranckPachot