All geek questions in one place

High Volume Handling OutOfMemoryException

We upload a large flat file to BizTalk Server 2006 (original version, not R2) - about 125 MB. We run the card against it, and then take each line and call the stored procedure.

We get an OutOfMemoryException during orchestration processing, restarting the Windows service, using 2 GB of full memory and working again.

The server is 32-bit and configured to use the / 3GB switch.

I also split the stream into 3 hosts — one for reception, one for orchestration, and one for sending.

Anyone have any suggestions on handling this file to handle wihout error?

Thanks Creep

+3
source share
2 answers

If it is a flat file sent via a card, do you convert it to XML correctly? The increase in size can be huge. XML can easily add a factor of 5-10 times on a flat file. Especially if you use descriptive or long xml tag names (which would usually be).

Something simple that you could try is to rename the xml nodes to shorter names, depending on the number of records (sounds a lot), this can significantly affect the amount of your memory.

, , , ( , ). . , , , 125 , , , , .

+3

? Transform? - . . , , .

+2

Source: https://habr.com/ru/post/1739143/

More articles:


All Articles