How get total row count in Azure Table Storage?

Question

How get total row count in Azure Table Storage?

Answer 1

Please note that this feature is not supported just yet in Azure Table Storage. One way to do so would be to list all entities in a table and get their count. Depending on the size of your table, it may turn out to be a really expensive and long operation. You may look into query projection functionality to limit the data returned by Windows Azure Table Storage Service and thus controlling the cost and time of the operation.

Hope this helps.

Thanks

Gaurav

Answer 2

You could maybe benefit from the Group transaction support inside a partition. Store an entity responsible for holding the total numbers. 

Then on each new insert of "the other entity" you should also increment the count on your totalentity. 

It will reduce the query you would have to do on the table a lot. 

/Rasmus

---

Best regards Rasmus Christensen

Answer 3

Gaurav,

Is this feature supported now to return the count (or) it is yet to be implementated?

Answer 4

This feature is not yet implemented. Unfortunately I don't know when this will be implemented.

Hope this helps.