CODEWITHSUNDEEP
azure-cosmosdb
Slicc
Slicc

Reputation: 3435

Select query getting "Request timed out"

I have a document db collection containing approximately 4 million items.

I run a query of the form:

SELECT * FROM c WHERE c.ItemDate >= "2015-01-01" AND c.ItemDate < "2017-07-31"

This query would ultimately enumerate most items in the collection, but not all (as most items exist in that range). When I run the query in the azure portal I get an error like ": Request timed out"

I was under the impression that DocumentDb would return paged results, and I would ultimately use a continuation token to retrieve subsequent paged data. And this instance would just return documents as they were found.

Is there anything I can do with this query to make this work?

Upvotes: 0

Views: 1152

Answers (1)

gaurang vyas
gaurang vyas

Reputation: 66

put this one

SELECT * FROM c WHERE (ItemDate >= "2015-01-01" AND ItemDate < "2017-07-31")

Upvotes: 1

Related Questions