Transactions and Continuation tokens in Windows Azure Storage Tables -
how many transactions fired retrieving 1200 entities in azure storage tables, keeping continuation tokens in mind.
i have read " windows azure tables returns maximum of 1000 entities in single request , returns continuation token when more results(remaining 200 entities) available." see @ (http://blog.smarx.com/posts/windows-azure-tables-expect-continuation-tokens-seriously).
because azure charges on basis of no. of transactions perform on cloud; want know: how many transactions executed single request returns 1200 entities(rows) continuation token after 1000th entity(row) result?
how many transactions executed single request returns 1200 entities(rows) continuation token after 1000th entity(row) result?
it depends. documentation states windows azure table returns maximum of 1000 entities in single request
. means in case, minimum number of transactions 2 maximum number of transactions 1200. depends on how data partitioned , load on storage account. more partitions have, chances you'll receive lesser data per request more transaction. again request execution time (server side) need taken consideration because if execution takes more allocated time, service return partial data.
based on documentation here: http://msdn.microsoft.com/en-us/library/windowsazure/dd179421.aspx, can expect continuation token if 1 or more conditions true:
- if number of entities returned exceeds 1000.
- if server timeout interval exceeded.
- if query crosses partition boundary.
Comments
Post a Comment