I have the need to continuously build large strings in a loop and save them to database wich currently occasioanlly yields an OutOfMemoryException
.
What is basically going on here is I create a string using XmlWriter
with StringBuilder
based on some data. Then I call a method from an external library that converts this xml string to some other string. After that the converted string is saved to the database. This whole thing is done repeatedly in a loop about a 100 times for different data.
The strings by itself are not too big (below 500kByte each) and the process memory is not increasing during this loop. But still, occasionally I get a OutOfMemeoryExcpetion
within StringBuilder.Append
. Interestingly this exception does not result in a crash. I can catch that exception and continue the loop.
What is going on here? Why would I get an OutOfMemoryException
allthough there is still enough free memory available in the system? Is this some GC heap problem?
Given that I can't circumvent converting all these strings, what could I do to make this work reliably? Should I force a GC collection? Should put a Thread.Sleep
into the loop? Should I stop using StringBuilder
? Should simply retry when confronted with a OutOfMemoryException
?