- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
Hello all,
From Microsoft documentation
You should lower the batch size if in the following instances:
- When processing large messages
- When database round trips are not your bottleneck
Why should i lower the batch size when i’m processing large messages? If i get it corectly this means that this action will translate into more round trips to the database.
For large message it is not better for me to have less round trips to the database?
Best regards
-
Hi Alex,
When you have large message, obviously it will take longer to process the message, hence occupy more CPU cycle and impact biztalk server performance. If you have a large batch size with large messages, the impact to biztalk server performance will be enormous.
The reason there’s more round trip to database when batch size is smaller is as follow: assuming you have 100 messages that need to be processed. If normal batch size is 20 messages, only 5 round trips to the database (MessageBox) is required in order to process all 100 messages. However, if the batch size is only 10 messages, it will need 10 round trips to the database (MessageBox) is required in order to process all 100 messages.
I hope this answers your questions.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.