Can I insert millions of lines into one section? (good load balancing is not required)

I've designed a data access layer for a worker role that will perform range queries and batch inserts on a single Azure Table. This section could potentially contain millions of lines.

As long as this partition will only be consumed by a few workers, with reasonable access speed, and good performance is not a critical requirement, are there any problems? Is there a limit on the size of the rowkey index?

Of course, I read Real World: Designing a Scalable Partitioning Strategy for Storing Windows Azure Tables .

+3


source to share


1 answer


The limit on the size of the partition that I know of is not specified.

Be aware that there is a limit on the number of operations per partition (500 / sec) and storage availability is at the partition level (i.e.: if a partition goes down, everything inside it goes down)



Obviously, batch inserts will be limited to no more than 100 objects at a time

+3


source







All Articles