I have a collection of 7 documents. 6 docs are about 1kb size and one is about 15kb.
Documents have a field named Email.
In Azure portal, in CosmosDB data explorer, i do simple query:
{"Email":/^co*/}
This returns all documents whose Email property starts with co (in this case its always 1 document returned). Now, when i run this query repeatedly, i get RU charges that vary from 6.98 to 104.99!
I emphasise, all of this happen in CosmosDB data explorer in Azure portal. Collection doesn't change during test. Noone else does any db queries while i am running tests.
Now this is complete mistery for me. I thought request charge is deterministic and that if collection and query don't change that request charge would be the same. This is 15 times different.
Does anyone have any explanation?