We are currently investigating our options regarding the storage options for a new application. Cosmos DB is on our radar and I stumbled upon these docs regarding hierarchical data.
The example uses the order/orderdetails scenario and that model closely relates to our model. But I have some questions about whether cosmos db is still a good fit if the number of orderlines is very large, say 10000 lines. How would that work in terms of updating a select set of orderlines, would we need to read the whole document in memory and how cost effective would such scenario be?