Page 1 of 1
Very slow (? hang ?) on SS_SAVE
Posted: Tue Apr 29, 2025 12:50 pm
by jtaylor___
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 determine what's taking so long?
Thanks
Re: Very slow (? hang ?) on SS_SAVE
Posted: Tue Apr 29, 2025 4:16 pm
by jonboy49
I have no clue as to a direct answer to your problem - but I can't help but wonder if there is not a better approach. Frankly I'm amazed that the process didn't just blow up at some point.
A multi-million-row spreadsheet seems insane - nobody can usefully work with that.
Can it not be grouped to produce separate files or for that matter multiple sheets within one file?
Re: Very slow (? hang ?) on SS_SAVE
Posted: Wed Apr 30, 2025 12:42 pm
by jtaylor___
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 save operation didn't finish in the time I had to work with.