Closed drfaustusfade closed 4 years ago
to match and to considerably speed up 5w queries
db.beneficiaries.createIndex( { reporting_period: 1, organization_tag: 1, admin0pcode: 1, cluster_id: 1 } );
also additionally for project listing db.project.createIndex( { "admin0pcode": 1, "project_status": 1 } )
db.project.createIndex( { "admin0pcode": 1, "project_status": 1 } )
Updated PROD
to match and to considerably speed up 5w queries
also additionally for project listing
db.project.createIndex( { "admin0pcode": 1, "project_status": 1 } )Updated PROD