java导出excel组件alibaba easyexcel和apache poi性能对比

java导出excel组件alibaba easyexcel和apache poi性能对比

• 背景：
  开发中出现web页面导出记录到excel导致服务oom奔溃，代码中使用apache poi组件导出，准备使用alibaba easyexcel组件进行优化，所以进行性能测试比较
• 参数如下：
  其他参数：导出excel是xlsx文本，20列，单个数据长度10英文字符或数字

组件	alibaba easyexcel	apache poi
jvm参数	-Xms500M -Xmx500M -XX:+PrintGCDetails	-Xms500M -Xmx500M -XX:+PrintGCDetails
插入数据	10W	10W
执行时间	22100	109912
执行结果	成功导出	jvm OOM

• alibaba easyexcel执行jvm打印

Heap
 PSYoungGen      total 142336K, used 65723K [0x00000000f5980000, 0x0000000100000000, 0x0000000100000000)
  eden space 114176K, 56% used [0x00000000f5980000,0x00000000f98a6de8,0x00000000fc900000)
  from space 28160K, 3% used [0x00000000fc900000,0x00000000fca08000,0x00000000fe480000)
  to   space 28160K, 0% used [0x00000000fe480000,0x00000000fe480000,0x0000000100000000)
 ParOldGen       total 341504K, used 17083K [0x00000000e0c00000, 0x00000000f5980000, 0x00000000f5980000)
  object space 341504K, 5% used [0x00000000e0c00000,0x00000000e1caee98,0x00000000f5980000)
 Metaspace       used 17673K, capacity 17908K, committed 18048K, reserved 1064960K
  class space    used 2073K, capacity 2148K, committed 2176K, reserved 1048576K

• apache poi 执行jvm打印

Heap
 PSYoungGen      total 157696K, used 145408K [0x00000000f5980000, 0x0000000100000000, 0x0000000100000000)
  eden space 145408K, 100% used [0x00000000f5980000,0x00000000fe780000,0x00000000fe780000)
  from space 12288K, 0% used [0x00000000fe780000,0x00000000fe780000,0x00000000ff380000)
  to   space 12288K, 0% used [0x00000000ff400000,0x00000000ff400000,0x0000000100000000)
 ParOldGen       total 341504K, used 341325K [0x00000000e0c00000, 0x00000000f5980000, 0x00000000f5980000)
  object space 341504K, 99% used [0x00000000e0c00000,0x00000000f59536b8,0x00000000f5980000)
 Metaspace       used 11751K, capacity 11862K, committed 12160K, reserved 1060864K
  class space    used 1317K, capacity 1367K, committed 1408K, reserved 1048576K
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
	at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1700)
	at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1303)
	at org.apache.xmlbeans.impl.store.Saver$TextSaver.emit(Saver.java:1190)
	at org.apache.xmlbeans.impl.store.Saver$TextSaver.emitElement(Saver.java:962)
	at org.apache.xmlbeans.impl.store.Saver.processElement(Saver.java:476)
	at org.apache.xmlbeans.impl.store.Saver.process(Saver.java:307)
	at org.apache.xmlbeans.impl.store.Saver$TextSaver.saveToString(Saver.java:1864)
	at org.apache.xmlbeans.impl.store.Cursor._xmlText(Cursor.java:546)
	at org.apache.xmlbeans.impl.store.Cursor.xmlText(Cursor.java:2436)
	at org.apache.xmlbeans.impl.values.XmlObjectBase.xmlText(XmlObjectBase.java:1500)
	at org.apache.poi.xssf.model.SharedStringsTable.getKey(SharedStringsTable.java:135)
	at org.apache.poi.xssf.model.SharedStringsTable.addEntry(SharedStringsTable.java:181)
	at org.apache.poi.xssf.usermodel.XSSFCell.setCellValue(XSSFCell.java:453)
	at org.apache.poi.xssf.usermodel.XSSFCell.setCellValue(XSSFCell.java:417)
	at algorithm.cache.excel.poi.ExcelExportUtil.export(ExcelExportUtil.java:117)
	at algorithm.cache.excel.poi.ExcelExportUtil.main(ExcelExportUtil.java:226)

• 结论：
  开发web后台导出记录10W条，easyexcel可以很好支持，apache poi会出现oom，jvm参数设置不足时可能导致程序崩溃。