Would there be a difference in RU consumption when you query directly in cosmos vs. fetching the records via BE?
I have a container where there are 100s of documents (in byte size) with same partition key. When I query by a partition key, then I see higher RU consumption.
What I want to know is, Is there any difference in RU if I access the same query using SDK from my .NET application?
Sample document: Here stockNumber
is partition key. I have 300 documents with same partition key in the container.
{
"stockNumber": "123",
"type": "note",
"createdBy": "gp",
"lastUserId": "User4",
"content": "Content4",
"contentUrl": null,
"contentType": "text/plain",
"createdAt": "2024-06-06T15:19:30.63186-04:00",
"tags": [
"important"
],
"status": "active",
"source": "manual",
"id": "6735c189-3eff-4ec3-8c88-fea013b57340"
}
Query:
SELECT * FROM c WHERE c.stockNumber = '123'
RUs: 23.62