search

randym / axlsx

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
MIT License
2.62k stars 695 forks source link

Performance reduction with rails 5.2 #656

Open nikhilsojan opened 4 years ago

nikhilsojan commented 4 years ago

Hi I was using axlsx to create a workbook , stream and write to a downloadable xlsx file with rails 4.2. It used to take less than 60 seconds to create a downloadable xlsx file with 40,000 records, along with currency and date formatting. After upgrade to rails 5.2 , no more than 10,000 records can be added under 60 seconds. The total time includes fetch from db, parsing, excel creation and sending for download out of which xlsx_package.to_stream.read takes more time than it used to Is there a reason for the performance reduction?

olegykz commented 3 years ago

hey, check the discussion here

w3villa-amit commented 2 years ago

Any Update on this i am facing the same issue the performance decrement in rails 5.2.