I want to delete items from a CosmosDB collection using a simple query filter:
db.getCollection('RequestLog').remove({ "ApplicationId": { $eq: "myValue" } })
I get the following error:
Request rate is large. More Request Units may be needed, so no changes were made. Please retry this request later.
The RequestCharge property has the value of 46963.
The price for 40000 RUs at Azure is nearly $2400/month - which I think is way too high.
I am doing something wrong?
Why is the RequestCharge so big for a query using an index key?
- I have an ascending index key on the
ApplicationIdcolumn. The collection has about 100,000 items. - The collection has the
Shard keyvalue of/ApplicationId.