Saturday 15 August 2015

c++ - Multiple connections updating same table -


I have a code that will create multiple connections for the database ) (All threads reach the same table) Each thread updates sets of different rows in the same table. In such a situation, to ensure there is no problem updating the table, mutex is required? What is the standard?

I think the task of maintaining the integrity of the data is more "MySQL side".

Overlapping data access can be controlled by table locking requests and rollback logic / transactions, but if you are working on different lines, then data should not be affected in corruption, in case Update thread table together Database server should handle properly.

No comments:

Post a Comment