| Orders |
systemID, shipping.company, count
|
25x |
986.3 ms |
1403 ms |
-
|
616450
|
db.Orders.createIndex({"systemID": 1, "shipping.company": 1, "count": 1})
|
| Orders |
systemID, type, count
|
14x |
2833.0 ms |
18357 ms |
-
|
555268
|
db.Orders.createIndex({"systemID": 1, "type": 1, "count": 1})
|
| Orders |
systemID, _stockDoc.product, totalOrders
|
9x |
5881.6 ms |
9146 ms |
-
|
476406
|
db.Orders.createIndex({"systemID": 1, "_stockDoc.product": 1, "totalOrders": 1})
|
| Orders |
systemID, _id.month, _id.day
|
7x |
5546.3 ms |
8108 ms |
-
|
271768
|
db.Orders.createIndex({"systemID": 1, "_id.month": 1, "_id.day": 1})
|
| Orders |
systemID, totalOrders
|
8x |
4206.1 ms |
5279 ms |
-
|
269192
|
db.Orders.createIndex({"systemID": 1, "totalOrders": 1})
|
| Orders |
systemID, _id.method, totalOrders
|
6x |
5401.0 ms |
6310 ms |
-
|
194436
|
db.Orders.createIndex({"systemID": 1, "_id.method": 1, "totalOrders": 1})
|
| Orders |
systemID, dates.shippedDate, _id.month, _id.day
|
6x |
4068.7 ms |
6153 ms |
-
|
146472
|
db.Orders.createIndex({"systemID": 1, "dates.shippedDate": 1, "_id.month": 1, "_id.day": 1})
|
| Orders |
systemID, inventoryStatus.warehouse, totalOrders
|
6x |
3370.2 ms |
4178 ms |
-
|
121326
|
db.Orders.createIndex({"systemID": 1, "inventoryStatus.warehouse": 1, "totalOrders": 1})
|
| Orders |
systemID, inventoryStatus.delivery
|
16x |
425.2 ms |
541 ms |
-
|
108848
|
db.Orders.createIndex({"systemID": 1, "inventoryStatus.delivery": 1})
|
| Clients |
systemID, name
|
21x |
165.2 ms |
669 ms |
-
|
72849
|
db.Clients.createIndex({"systemID": 1, "name": 1})
|
| Orders |
systemID, createdAt, _id
|
18x |
182.2 ms |
1105 ms |
-
|
59022
|
db.Orders.createIndex({"systemID": 1, "createdAt": 1, "_id": 1})
|
| Orders |
systemID, payment.status, inventoryStatus.sales
|
16x |
191.6 ms |
239 ms |
-
|
49056
|
db.Orders.createIndex({"systemID": 1, "payment.status": 1, "inventoryStatus.sales": 1})
|
| Ticket |
systemID, status, assignedTeam, uid
|
24x |
60.7 ms |
66 ms |
-
|
34968
|
db.Ticket.createIndex({"systemID": 1, "status": 1, "assignedTeam": 1, "uid": 1})
|
| ShippingList |
systemID
|
12x |
130.6 ms |
334 ms |
12x
|
18804
|
db.ShippingList.createIndex({"systemID": 1})
|
| Clients |
systemID, name, createdAt
|
8x |
262.1 ms |
611 ms |
-
|
16776
|
db.Clients.createIndex({"systemID": 1, "name": 1, "createdAt": 1})
|