OutofMemoryException on LOH

Asked Jan 21 '14 at 11:57

Active Jan 21 '14 at 11:57

Viewed 142 times

I've a simple c# application which tries to read and write a single row to SQL Server Database. That row contains an Image field that I fill with 100 MB or little greater than.

Every time I get System.OutOfMemoryException.

So, instead to read and write the array bytes in a single instruction, I would like do that in more than one instruction by appending all together.

Is it possibile accomplish that through SqlDataAdapter?

asked Jan 21 '14 at 11:57

bit

Are you trying to write a single 100MB blob to the database? – Sean Jan 21 '14 at 12:04
1

possible duplicate of [Memory effective way to read BLOB data in C#/SQL 2005](http://stackoverflow.com/questions/1487808/memory-effective-way-to-read-blob-data-in-c-sql-2005) – Konrad Kokosa Jan 21 '14 at 12:09
why not just use file system :) – Max CHien Oct 06 '18 at 08:56
LOH OOM could be raised by memory fragmentation, you can try compact LOH with .net 4.5 – Max CHien Oct 06 '18 at 09:00

OutofMemoryException on LOH

0 Answers0