17
Views
1
Comments
The problem with the lock table
Question

Hello, here is a description of the problem

When traversing a table, Update and Create operations are carried out during traversing. Will this lock the table? Or is there a good solution? Please tell me.Thank you for your answer


Rank: #56

Hi QQQ OOO,


It won't lock the table.

If the amounts of records you are looping and creating / updating is big, you might want to think about bulk inserts way more performant than N calls of Create / Insert.


Regards,
João