In the implementation of pivot.GenerateExport()
we are using a List to store the generated export objects.
There are a few limitations of the Framework that may cause problems in such huge exports:
1) Currently, the Microsoft implementation of a List<T> can hold up to Int32.MaxValue
count of objects ( just above 2 billion ).
2) Also in the Microsoft implementation of the CLR there's a maximum of 2GB
That said if an object that is above 2GB is created the system throws OOM.
With the .Net Framework 4.5 Microsoft introduce the gcAllowVeryLargeObjects
element, that when set enables arrays that are greater than 2 GB in size. You can find more information about it here
Could you please give setting it a try and let us know whether this helps with the exception:
Keep in mind that in order for it to work:
1) The platform has to be 64 bit
2) The application framework version have to be 4.5
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.