EPPlus大型数据集与问题内存溢出异常 [英] EPPlus Large Dataset Issue with Out of Memory Exception
问题描述
系统内存溢出异常。我看到保存时内存流只刷新。我们有1.5 - 2GB数据集
System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets.
我使用EPPlus 3.1.3.0版本
I am using EPPlus Version 3.1.3.0
我们做了以下的中。代码
We do the following in code.
我们通过
--> Create a Package
--> each table in the datareader
--> Add WrkkSheet to the Package
--> Dispose Each table.
--> Save the Package.
每个数据表是300毫克规模达15表出来形成系统。
Each Datatable is of a 300Mg Size up to 15 Tables out form the System.
这是造成问题,我已详细@ HTTPS looged这//epplus.codeplex.com/workitem/15085
This is causing a issue, I have looged this in detail @ https://epplus.codeplex.com/workitem/15085
我还是希望能够使用EPPlus它非常漂亮的API。但有一个更好的办法来腾出一个工作表,一旦我们把它添加到包。
i still want to be able to use EPPlus its very nice API. but is there a better way to free up a worksheet once we add it to the package.
感谢您的帮助。
推荐答案
我有这个问题,但我通过切换的目标平台
选项固定它,从 86
到 64
或任何CPU
。 (右键单击该项目,然后选择属性,然后在选项卡生成,然后在目标平台中选择64)
I had this problem, but I fixed it by switching the option of "Platform target
", from x86
to x64
or "Any CPU
". ( right click on the project, then select "Properties", then the tab "Build", then on "Platform target" select "x64" )
的问题是,对于平台 86
您只能使用约1.8 GB的RAM。对于平台 64
,你没有这个限制。
The problem is that for platform x86
you can use only about 1.8 GB of RAM. For platform x64
, you do not have this limitation.
这篇关于EPPlus大型数据集与问题内存溢出异常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!