调试时,Epplus Save()、SaveAs()等方法的运行速度非常慢

环境-Windows 10、Visual Studio 2017、netcore2.0、调试版本。

在调试时使用Epplus 4.1.1保存Excel文件时,保存操作所需的时间比我预期的要长得多。

以下是使用Debug运行时的一些计时->开始调试

Saving 100 rows in 2065ms.
Saving 200 rows in 2050ms.
Saving 400 rows in 4003ms.
Saving 800 rows in 11360ms.
Saving 1600 rows in 18377ms.
Saving 3200 rows in 34139ms.

使用Debug运行时也是如此->无需调试即可启动

Saving 100 rows in 401ms.
Saving 200 rows in 49ms.
Saving 400 rows in 28ms.
Saving 800 rows in 58ms.
Saving 1600 rows in 94ms.
Saving 3200 rows in 198ms.

确定目标时。NET Framework 4.6.1,调试时的结果要好得多-

Saving 100 rows in 215ms.
Saving 200 rows in 26ms.
Saving 400 rows in 42ms.
Saving 800 rows in 78ms.
Saving 1600 rows in 146ms.
Saving 3200 rows in 279ms.

我显然知道调试速度很慢,但这只是一个很小的数据量。在调试目标时,我是否可以做些什么来加快速度。NET Core 2.0?

--

下面是生成上述输出的程序-

namespace ConsoleApp9
{
    using System;
    using System.Collections.Generic;
    using System.IO;
    using System.Text;
    using System.Linq;
    using System.Diagnostics;

    using OfficeOpenXml;

    public class Foo
    {
        public string Name { get; set; }
        public int Number { get; set; }
        public char? Character { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);

            IEnumerable<Foo> RandomFoo()
            {
                var random = new Random();
                const string chars = "ABCDEFGHIJKLH";
                while (true)
                {
                    yield return new Foo
                    {
                        Character = random.NextDouble() < .1 ? null : (char?) 'A',
                        Number = random.Next(0, 10),
                        Name = new string(Enumerable.Repeat(chars, 8)
                            .Select(x => x[random.Next(x.Length)])
                            .ToArray()
                        )
                    };
                }
            }

            for (var i = 100; i <= 1000000; i *= 2)
            {
                var sw = Stopwatch.StartNew();

                var stream = new MemoryStream();
                using (var package = new ExcelPackage(stream))
                {
                    var sheet = package.Workbook.Worksheets.Add("Sheet");
                    var foos = RandomFoo().Take(i);
                    sheet.Cells["A1"].LoadFromCollection(foos);

                    package.Save(); // very long operation here
                    stream.Seek(0, SeekOrigin.Begin);
                }

                var file = new FileInfo("test.xlsx");
                using (var fileStream = file.Create())
                {
                    stream.CopyTo(fileStream);
                }

                Console.WriteLine($"Saving {i} rows in {sw.ElapsedMilliseconds}ms.");
            }
        }
    }
}