Apache POI性能(Apache POI Performance)

 我遇到了Apache POI的性能问题。 我已经阅读了它提到性能测试的FAQ。 我已经通过注销和4gb堆运行了这个测试，并且我无法让测试运行速度超过22秒。 
 
 这是我正在运行的测试： http : //svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java 
 
 常见问题解答表示，如果我不能在3秒内以50,000行和50列的速度运行“这个问题与您的环境相关”的测试。 我读过关于禁用poi日志记录和增加堆大小的其他评论，但似乎没有任何帮助。 
 
 我还能检查什么来修复我的环境？ 
 
 机器规格（个人台式机）： 
 
CPU: Intel i7 8-cores
RAM: 16GB
OS: Windows 7 64bit
JDK: 1.8.0_66
POI: 3.13
JVM Params: -Xmx4g -Xms4g -Dorg.apache.poi.util.POILogger=org.apache.poi.util.NullLogger
Command Arguments: XSSF 50000 50 0
 
 我还应该提到我使用的Apache POI jar来自maven central 
 
 我在github上创建了一个测试项目，你可以简单地克隆项目并运行： 
 
mvn exec:java
 
 我硬编码我正在使用的参数，所以你不必输入任何特殊的命令行。 文件说这应该在3秒内运行。 
 
 测试项目位于： https ： //github.com/mikedehaan/poi-test 

I'm having performance problems with Apache POI. I've read the FAQ where it refers to a performance test. I've run this test with logging off and 4gb of heap and I can't get the tests to run faster than 22 seconds.
 
This is the test I'm running: http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java
 
The FAQ says that if I can't get this test to run in under 3 seconds with 50,000 rows and 50 columns that "the problem is with your environment". I've read other comments around the web referring to disabling poi logging and increasing the heap size, but nothing seems to help.
 
What else can I check to fix my environment?
 
Machine Specs (Personal desktop machine):
 
CPU: Intel i7 8-cores
RAM: 16GB
OS: Windows 7 64bit
JDK: 1.8.0_66
POI: 3.13
JVM Params: -Xmx4g -Xms4g -Dorg.apache.poi.util.POILogger=org.apache.poi.util.NullLogger
Command Arguments: XSSF 50000 50 0
 
I should also mention that the Apache POI jars I'm using came from maven central
 
I've created a test project on github where you can simply clone the project and run:
 
mvn exec:java
 
I hard coded the parameters I'm using so you do not have to enter anything special on the command line. The documentation says this should run in under 3 seconds.
 
The test project is located here: https://github.com/mikedehaan/poi-test

原文：https://stackoverflow.com/questions/34246083