# exportExcelTest **Repository Path**: wayhood_admin/exportExcelTest ## Basic Information - **Project Name**: exportExcelTest - **Description**: No description available - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2020-07-10 - **Last Updated**: 2023-02-24 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # exportExcelTest 多语言导出Excel测试 ### 环境 * linux centos7.x * cup 8 core * memory 32G * clound hosting ### 测试数据 ``` data/test_data.sql.zip ``` ### dotnet core 运行 ``` /usr/bin/time -v bin/dotnet-excel -c conf/dotnet-excel.yaml ``` 结果 ``` Command being timed: "bin/dotnet-excel -c conf/dotnet-excel.yaml" User time (seconds): 597.89 System time (seconds): 9.88 Percent of CPU this job got: 101% Elapsed (wall clock) time (h:mm:ss or m:ss): 10:01.10 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 2475440 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 0 Minor (reclaiming a frame) page faults: 630254 Voluntary context switches: 8220 Involuntary context switches: 961 Swaps: 0 File system inputs: 0 File system outputs: 129744 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ``` ### golang 默认运行 ``` /usr/bin/time -v bin/golang-excel -conf conf/golang-excel.yaml ``` 结果 ``` Command being timed: "bin/golang-excel -conf conf/golang-excel.yaml" User time (seconds): 154.02 System time (seconds): 32.15 Percent of CPU this job got: 124% Elapsed (wall clock) time (h:mm:ss or m:ss): 2:29.49 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 8027400 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 0 Minor (reclaiming a frame) page faults: 1442995 Voluntary context switches: 34968 Involuntary context switches: 4693 Swaps: 0 File system inputs: 0 File system outputs: 124152 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ``` 单核运行 ``` /usr/bin/time -v bin/golang-excel -conf conf/golang-excel-one.yaml ``` 结果 ``` Command being timed: "bin/golang-excel -conf conf/golang-excel-one.yaml" User time (seconds): 108.15 System time (seconds): 15.19 Percent of CPU this job got: 100% Elapsed (wall clock) time (h:mm:ss or m:ss): 2:02.82 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 9042988 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 0 Minor (reclaiming a frame) page faults: 1846768 Voluntary context switches: 28522 Involuntary context switches: 1077 Swaps: 0 File system inputs: 0 File system outputs: 124152 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ``` ### java 运行 ``` /usr/bin/time -v java -jar bin/java-excel.jar conf/java-excel.yaml ``` 结果 ``` Command being timed: "java -jar bin/java-excel.jar conf/java-excel.yaml" User time (seconds): 142.80 System time (seconds): 22.38 Percent of CPU this job got: 189% Elapsed (wall clock) time (h:mm:ss or m:ss): 1:26.98 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 4339988 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 0 Minor (reclaiming a frame) page faults: 514587 Voluntary context switches: 33516 Involuntary context switches: 48034 Swaps: 0 File system inputs: 8 File system outputs: 1673632 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ``` ### php 运行 ``` /usr/bin/time -v php bin/php-excel.php conf/php-excel.yaml ``` 先去看集电视区，等待结果 ``` /usr/bin/time -v php bin/php-excel.php conf/php-excel.yaml Command being timed: "php bin/php-excel.php conf/php-excel.yaml" User time (seconds): 2148.70 System time (seconds): 97.92 Percent of CPU this job got: 99% Elapsed (wall clock) time (h:mm:ss or m:ss): 37:29.67 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 12180012 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 1 Minor (reclaiming a frame) page faults: 5867866 Voluntary context switches: 28130 Involuntary context switches: 1545 Swaps: 0 File system inputs: 24 File system outputs: 123184 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 ``` ### 分析 * 速度 java > golang > .net core > php * 内存占用 .net core < java < golang < php * 文件大小 php < golang < dotnet < java