justin.swanhart's blog

concurrency

Taxonomy upgrade extras: 

I guess your feed system writes into the table in a serial fashion? Any concurrency is going to kill this method. The summary table will have very few rows, which will create very hot locks when the base table is modified. Deadlocks and lock wait timeout errors are likely.

Subscribe to RSS - justin.swanhart's blog