Getting data from query result taking a long time

Working with Data
,
3

Hi, and thanks. There are other indexes around various values I even created one for the Tracking Time but didn’t make any difference (Update: although this won’t make any difference anyway as I’m not selecting based on the TrackTime). An example document is as follows…

{
"_id" : LUUID("5e4cf57f-2b1d-2d4a-b158-b54c43b17364"),
"Event" : {
    "Code" : "22",
    "Description" : "example description"
},
"Confirmed" : [ 
    NumberLong(636469684832760000), 
    0
],
"Exported" : [ 
    NumberLong(636449680517180000), 
    0
],
"Location" : "locationA",
"SecondEvent" : {
    "_id" : LUUID("b838f2c5-033c-c64b-95b7-b636cca4d2bf"),
    "Code" : "1111",
    "Description" : "example description",
    "Default" : true,
    "Location" : {
        "Name" : "Default",
        "Code" : "AAA"
    },
    "EndOfLife" : false
},
"Ships" : {
    "Id" : "123456789-id",
    "Name" : "xyz",
    "Number" : "123456789",
    "Parts" : [ 
        {
            "Codes" : [ 
                {
                    "Number" : "987654321",
                    "Name" : "xyz",
                    "DeletedDate" : null
                }
            ],
            "TracNumbers" : [ 
                {
                    "Number" : "123456789",
                    "Name" : "abc",
                    "DeletedDate" : null
                }, 
                {
                    "Number" : "987654321",
                    "Name" : "xyz",
                    "DeletedDate" : null
                }
            ]
        }
    ],
    "Status" : 3
},
"Identifier" : {
    "_id" : null,
    "Number" : "123456789",
    "Code" : "987654321",
    "TrackNumber" : "123456789"
},
"TrackTime" : [ 
    NumberLong(636445689000000000), 
    60
],
"UserEmail" : "joe.blogs@mail.com",
"Version" : "0.0.2"

}

Thanks