POI性能 [英] POI performance
问题描述
我用我的J2EE Web应用程序POI生成一个工作簿。
然而,我发现,POI大约需要3分钟来创建一个工作簿25K行(每个约15列)。
这是一个POI性能问题,或者是有理由采取那么多的时间?
是否有更好的表现已知的其它的API?
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 ?
推荐答案
我会很惊讶地看到POI花费那么多时间来产生这样的文件。我只是生成了表30000行×10细胞在18岁左右(不格式化,要公平)。其原因可能是下列之一:
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记录可能会被打开,描述这里
- 您是从交换内存运行
- 您的VM可用堆可能会非常低
这篇关于POI性能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!