- This topic has 1 reply, 1 voice, and was last updated 8 years, 3 months ago by
.
Viewing 1 reply thread
-
Posts
-
-
Hi, how i can resolve this issue?
i receive many orders in a folder, then biztalk receive this orders and send to SQL.
the problem is when biztalk load all orders without wait for the process finished of the first order, opening multiple connections and blocked my DataBase.
how i can avoid this?
kind regards
p.d. bad english ? better spanish [:D]
-
If its a requirement to process the messages in order, then implement singleton pattern. Only one instance of orchestration will process the messages.
But if its not, I guess you need analyze the causes for database locks and try to avoid them.
-try using stored procedures
-minimize the scope of database transaction
-
Viewing 1 reply thread
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.