What is the common level of granularity of database contention? Is the contention usually on the table level, the row level or the cell level?
abist
I could be wrong but I'm going to guess it's going to be table level as row-level or cell-level seems too specific for a user or service, but a table makes much more sense.
ankit1990
I agree with @abist. The contention typically is at a table-level. Further, in case of sharded databases, some shards could be a cause of contention rather than the entire table itself.
What is the common level of granularity of database contention? Is the contention usually on the table level, the row level or the cell level?
I could be wrong but I'm going to guess it's going to be table level as row-level or cell-level seems too specific for a user or service, but a table makes much more sense.
I agree with @abist. The contention typically is at a table-level. Further, in case of sharded databases, some shards could be a cause of contention rather than the entire table itself.