INSERTing into same table using Multiple thread from Webmethod

Third Party Software
Enthusiast

INSERTing into same table using Multiple thread from Webmethod

Hi

This is regarding WebMethod-Teradat interface. We are required to run an INSERT operation from WebMethod using multiple threads. Now I want to know how this going to impact the teradata database transaction processing. If each thread is trying to  write it's data into the same table, then will there be any lock contention ? 

An early reply will be appreciated.

Thanks in advance.

1 REPLY

Re: INSERTing into same table using Multiple thread from Webmethod

The first insert thread would hold the Write lock on the table until the process is completed. Even though you try to use multiple threads on a transanction, teradata should handle it serially for maintaining the data integrity.

You could try loading the data in few stage tables parallely and have one merge or insert query to main tables. This time Teradata Teradata will take care of inserting the data in bulk load. Hope this helps.