rubyXL icon indicating copy to clipboard operation
rubyXL copied to clipboard

High Memory Usage Issue

Open aleql opened this issue 6 years ago • 4 comments

My issue is that i need to generate an Excel file of around 230000 rows, which with the gem Axlsx consumed a large amount of memory, roughly 4 GB. I tried to change my app to use RubyXL Version 3.4.6 expecting to improve memory performance but it remained almost the same. Am I using the a wrong version or this high memory usage is an expected performance? Thanks in advance

aleql avatar Nov 08 '19 20:11 aleql

I have the same issue. Did you find out a way to decrease memory consumption?

Nerian avatar Dec 29 '19 23:12 Nerian

Same here, for about 4000 rows. Is there a workaround by batch writing rows?

remi-wakeo avatar Jun 15 '20 10:06 remi-wakeo

consider to use this guys https://github.com/Paxa/fast_excel its backend using C so it should be fast

laptopmutia avatar Jan 01 '22 10:01 laptopmutia

Note that fast_excel is a write-only library. Reading is not supported :(

Michoels avatar Dec 18 '23 14:12 Michoels