Closed a-yahaha closed 4 months ago
Thanks for your issue. Is your local machine environment different from your server? The performance is also impacted by these factors: OS, Go language version, Excelize library version, hardware such as CPU, memory, storage equipment (HDD or SSD), etc. I don't have enough information to reproduce this issue, but here are some performance figures for your reference: Performance Figures. I'll close this issue, if you have any questions, please let me know to reopen this anytime.
本地测试代码
测试代码如下:
耗时
服务器上测试
代码如下
耗时
服务器的配置 8G 16G
问题
初步排查是 rows.Columns在服务端的性能很差,基本耗时都在这里。
有几个疑问
测试文件
测试文件: 100列4500行文本
测试数据100列4500行.xlsx