|
| I have a question about the message box and expected growth of the
database/log. My scenario is that I receive about 10000 items in a
flat file, these are split into an XML format and then processed
individually through an orchestration. At least 1/2 of these
Orchestrations dehydrate and wait several days for a response (so there
can easily be 50,000+ of these waiting for a response). The XML
processed is approximately 3.5K. I calculate this as ~30-35MB of data
being processed. Within the orchestration there is some new XML docs
being constituted so let's say I triple the size of the data inside of
the orchestration.
Here is the actual issue. My messagebox database most often generates
100MB-15GB transaction logs every 15 or so minutes. What is the engine
do that is generating this much traffic? Biztalk spends most of its
time with I/O and not so much actually processing. Are there best
practices within the orchestration to reduce the amounts of
reads/writes?
TIA,
Dave.
|
|