Search found 2 matches

by jtaylor___
Wed Apr 30, 2025 12:42 pm
Forum: HSSFR4
Topic: Very slow (? hang ?) on SS_SAVE
Replies: 2
Views: 10552

Re: Very slow (? hang ?) on SS_SAVE

Personally, I have no issue with the 65535 row limit for XLS. If you need more rows, you're probably doing something wrong.

That being said, management wants more that 65 K rows. I'm testing XLSX to find practical limits. By expanding the JVM heap, I was able to get 1 million rows added, but the ...
by jtaylor___
Tue Apr 29, 2025 12:50 pm
Forum: HSSFR4
Topic: Very slow (? hang ?) on SS_SAVE
Replies: 2
Views: 10552

Very slow (? hang ?) on SS_SAVE

I'm creating a very large XLSX file. At the 20 minute mark, it's finished creating 1 million rows, and the call stack shows procedure SS_SAVE. At the 9 hour mark, it's still in SS_SAVE. It seems unreasonable to me that it should take that long.

Is there anything I can do to speed it up, or to ...