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 .
source to share
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
source to share