monstertruck
New Member
I am developing a webapp in ASP.NET / C# with MySQL and Entity Framework. I want to use some counter columns that will frequently be updated by incrementing their value +1. I have a product table where the counters columns reside. I have a two questions:1) Should I use a second table for the counters? - The main product table will be read frequently, and if I update the row very frequently that can hurt performance, because the row will be locked each time the counters are being updates (I use InnoDB)2) What is the best way to make a +1 increment on a row using MySQL and Entity Framework. I don't mind that the counter will be 100% accurate, so if there are some update conflicts, I can catch them but I can pass without an update. I assume that most updated will be done fast and be included in the update.Thanks