- This topic has 1 reply, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hello
Yesterday my boss came in and asked me 2 questions.
1] How long will Biztalk take to process a 250MB XML file
2] How long will Biztalk take to process 10 x 25MB XML files
Now I know that it is dependent on so many things. CPU’s, load balancing, type of processing etc ….
But let’s assume the servers are well spec’d and the SQL servers can handle anything we throw at them ……
Is there a ballpark time frame of how long it will take a 250MB file to enter Biztalk be processed through a pipleine and deposited into an SQL server?Regards
JMan -
Wow Easiest way to know for sure is to build a simple sample.
What is your time constraint is probably a better question
If you need to process 250 MB in 30 seconds.. probably not. In 30 minute, probably.Schema complexity is really a big factor. Also if you need to break up the message into single message to insert into SQL. I also have no clue how well the SQL Adapter handles large data loads like that – guessing not well if at all.
See if these posts help you:
http://geekswithblogs.net/sthomas/archive/2004/08/17/9855.aspx
http://www.biztalkgurus.com/WhitePapers/Debatching-Options-Performance-BizTalk2004.html
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.