Graphql query for every collection is taking more than 20 seconds for both 1 or 100 records
- I’m using a shared M0 cluster
- No relationships for the collection
Collection name userjob
here is the realm schema :
{
"title": "userjob",
"properties": {
"_id": {
"bsonType": "objectId"
},
"createdAt": {
"bsonType": "number"
},
"jobId": {
"bsonType": "objectId"
},
"oldjobId": {
"bsonType": "string"
},
"location": {
"bsonType": "array",
"items": {
"bsonType": "string"
}
},
"numberOfHires": {
"bsonType": "int"
},
"owner": {
"bsonType": "string"
},
"ref": {
"bsonType": "string"
},
"stages": {
"bsonType": "array",
"items": {
"bsonType": "object",
"properties": {
"candidates": {
"bsonType": "int"
},
"overallCandidates": {
"bsonType": "int"
},
"candidatesData": {
"bsonType": "array",
"items": {
"bsonType": "object",
"properties": {
"candidateId": {
"bsonType": "objectId"
},
"complianceRateClass": {
"bsonType": "string"
},
"email": {
"bsonType": "string"
},
"firstName": {
"bsonType": "string"
},
"lastName": {
"bsonType": "string"
},
"lastPosition": {
"bsonType": "string"
},
"matchingScores": {
"bsonType": "string"
},
"oldId": {
"bsonType": "string"
},
"profileImageLink": {
"bsonType": "string"
},
"stageClass": {
"bsonType": "string"
},
"stage": {
"bsonType": "string"
},
"tags": {
"bsonType": "array",
"items": {
"bsonType": "object",
"properties": {
"addedAt": {
"bsonType": "number"
},
"auto": {
"bsonType": "bool"
},
"color": {
"bsonType": "string"
},
"createdAt": {
"bsonType": "number"
},
"hash": {
"bsonType": "string"
},
"internal": {
"bsonType": "bool"
}
}
}
}
}
}
},
"completedCandidates": {
"bsonType": "int"
},
"createdAt": {
"bsonType": "number"
},
"hasCompletedCandidates": {
"bsonType": "bool"
},
"icon": {
"bsonType": "string"
},
"id": {
"bsonType": "string"
},
"order": {
"bsonType": "int"
},
"title": {
"bsonType": "string"
}
}
}
},
"status": {
"bsonType": "string"
},
"title": {
"bsonType": "string"
},
"updatedAt": {
"bsonType": "number"
},
"vonqCampaigns": {
"bsonType": "array",
"items": {
"bsonType": "object",
"properties": {
"campaignId": {
"bsonType": "string"
},
"orderedProducts": {
"bsonType": "array",
"items": {
"bsonType": "object",
"properties": {
"jobBoardLink": {
"bsonType": "string"
},
"productId": {
"bsonType": "string"
}
}
}
},
"status": {
"bsonType": "string"
}
}
}
}
}
}