SQL adapter performance is very slow
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Applications Integration > SQL adapter performance is very slow




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    SQL adapter performance is very slow  
Niklas E


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
11-11-04 10:49 PM

Some of our files are split into a lot of smaller files, e.g. one message
per product/customer etc, because else BizTalk will lock the whole database
for other users and if something goes wrong, then all products/customers are
rolled back instead of only the problematic. This is not such a problem, but
in our case I have noticed that BizTalk is very slow with transactions when
doing this. When I turned off transaction support, the throughput increased
about 100 times. Am I missing some setting with the transactions or is it
supposed to be like this?

Best regards
Niklas E







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 08:30 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register