Post reply

General question about the Table Lock checkbox in Data Flow

  • April 13, 2011 at 5:18 am

    #237604

    Had a general question about the Table Lock Checkbox in Data Flow. If the Table Lock box is checked, and multiple threads are running to do an insert, does that mean if thread 1 is doing the insert, thread 2 will not be able to insert more data, since thread 1 has the table locked, thus slowing down the insert process? Again this is something I'm not clear on.

  • April 13, 2011 at 10:34 am

    #1311171

    If that is selected the table will be locked. Now depending on what you mean by threads it might be less relevant. If you are trying to do multiple bulk inserts within the same or different data-flows I would question that method. SQL may generate additional threads internally and that will usually enhance performance but you don't have a lot of control over that. Perhaps you can explain further.

    CEWII

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply