有效地向数据库添加大量文本(Efficiently adding large amounts of text to a database)

 我有一个C＃应用程序需要向SQL Server数据库添加大量文本（一行最多可以有1GB的文本）。 所以，我有一些看起来像的代码： 
 
SqlParameter param = command.Parameters.Add("@text", SqlDbType.NVarChar);
param.Value = new string(buffer);
 
 文本以块的形式添加，因此缓冲区为20 MB。 我试图通过重新使用缓冲区来减少内存压力（而不是每次我需要添加块时执行新的char [10000000]）。 我注意到的是ADO.NET似乎每次调用我的sproc时都会分配一个新的缓冲区。 每次调用sproc时，我都会看到我的进程的工作集几乎上升了20 MB。 
 
 现在，您可能认为这是因为“新字符串（缓冲区）”（我做过），但是当我这样做时，我会得到相同的行为 
 
param = command.Parameters.Add("@text", SqlDbType.Text, buffer.Length);
param.Value = buffer;
 
 有没有办法阻止ADO.NET每次向数据库添加一大块文本时进行额外的内存分配？ 
 
 谢谢！ 

I have a C# app that needs to add large amounts of text to a SQL Server database (one row could have up to 1GB of text). So, I have some code that looks like:
 
SqlParameter param = command.Parameters.Add("@text", SqlDbType.NVarChar);
param.Value = new string(buffer);
 
The text is added in chunks, so the buffer is say, 20 MB. I've tried to reduce memory pressure by re-using buffers (as opposed to doing a new char[10000000] every time I need to add a chunk). What I'm noticing is that ADO.NET seems to be allocating a new buffer for every time my sproc is called. Every time the sproc is called, I see my process's working set go up by almost exactly 20 MB.
 
Now, you might think that's because of the "new string(buffer)" (I did), but I get the same behavior when I do
 
param = command.Parameters.Add("@text", SqlDbType.Text, buffer.Length);
param.Value = buffer;
 
Is there any way to prevent ADO.NET from doing the extra memory allocation every time I add a chunk of text to the database?
 
Thanks!

原文：https://stackoverflow.com/questions/1928600