POI表现 [英] POI performance

问题描述

我在我的J2EE Web应用程序中使用POI来生成一个工作簿。
但是，我发现POI需要大约3分钟才能创建一个25K行（每列大约15列）的工作簿。
这是一个POI性能问题，还是有理由花费大量的时间？
是否有其他的API已知，以获得更好的性能？

解决方案

我很惊讶看到POI花了这么多时间生成这样一个文件。大约18年代，我刚刚生产了一张30000行x 10个单元格的表单（没有格式化，公平）。原因可能是以下之一：

• POI记录可能已打开，如


• 你正在从交换内存中运行


• 您的VM可用堆可能很低

I am using POI in my J2EE web application to generate a workbook. However, i find that POI takes around 3 mins to create a workbook with 25K rows(with around 15 columns each). Is this a POI performance issue , or is it justified to take that much of time? Are there other APIs known for better performance ?

解决方案

I would be very surprised to see POI take that much time to generate such a file. I just generated a sheet with 30000 rows x 10 cells in about 18s (no formatting, to be fair). The cause might be one of the following:

• POI logging might be turned on, as described here
• you are running from swap memory
• your VM available heap might be very low

这篇关于POI表现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！