DioDocsExcelPerformanceTest/Program.cs at master · MESCIUSJP/DioDocsExcelPerformanceTest · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
using System;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;

namespace GcExcelPerformanceTest
{
    class Program
    {
        static void Main(string[] args)
        {
            double setTime = 0, getTime = 0, saveTime = 0, usedMem = 0;
            int row = 100000, col = 30;
            GC.Collect();

            long memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                GcExcelBenchmark.TestSetRangeValues_Double(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                GcExcelBenchmark.TestSetRangeValues_String(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                GcExcelBenchmark.TestSetRangeValues_Date(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                GcExcelBenchmark.TestSetRangeFormulas(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                GcExcelBenchmark.TestBigExcelFile(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                NPOIBenchmark.TestSetRangeValues_Double(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                NPOIBenchmark.TestSetRangeValues_String(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                NPOIBenchmark.TestSetRangeValues_Date(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);

            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                NPOIBenchmark.TestSetRangeFormulas(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            GC.Collect();

            memDiff = GetMaxTotalMemoryAllocation(() =>
            {
                NPOIBenchmark.TestBigExcelFile(row, col, ref setTime, ref getTime, ref saveTime, ref usedMem);
            });
            Console.WriteLine(string.Format("メモリ使用量：{0:N3} MB ", memDiff / 1024 / 1024));

            Console.ReadKey();
        }

        private static long GetMaxTotalMemoryAllocation(Action testAction)
        {
            var initMemory = GC.GetTotalMemory(true);
            var memoryUsages = new System.Collections.Generic.List<long>();
            var cancelSource = new CancellationTokenSource();
            var cancelToken = cancelSource.Token;
            var memUsageCounter = Task.Run(async () =>
            {
                try
                {
                    while (true)
                    {
                        memoryUsages.Add(GC.GetTotalMemory(false));
                        await Task.Delay(100, cancelToken);
                    }
                }
                catch (TaskCanceledException)
                {
                }
            });
            testAction();
            cancelSource.Cancel();
            memoryUsages.Add(GC.GetTotalMemory(false));
            var highMem = memoryUsages.Max();
            var memDiff = highMem - initMemory;
            return memDiff;
        }


    }
}