locked
How to set limit to ExecuteQuerySegmented in Windows Azure? RRS feed

  • Question

  • Hi All,

    Is the default return rows for ExecuteQuerySegmented is 1000? Can I increase or decrease the limit?

    Thanks

    Lax

    Wednesday, August 16, 2017 4:26 AM

All replies

  • A query against the Table service may return a maximum of 1,000 items at one time and may execute for a maximum of five seconds. If the result set contains more than 1,000 items, or if the query did not complete within five seconds, the response includes headers which provide the developer with continuation tokens to use in order to resume the query at the next item in the result set. Continuation token headers may be returned for a Query Tables operation or a Query Entities operation.

    For more information about continuation tokens, refer Query Timeout and Pagination. Also, refer this thread: Azure Table Storage query entity limitations.

    -----------------------------------------------------------------------------------------------------

    Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.

    • Proposed as answer by Md Shihab Wednesday, August 16, 2017 6:07 AM
    Wednesday, August 16, 2017 6:07 AM