Perf: Download coplaner XLSX - GET /coplaners.xlsx
Action -> Remove realtime export
trace-coplaner_exports-index-2023-01-17T212611_0100.log
GET /coplaners.xlsx coplaner_exports#index
params:
controller: coplaner_exports
action: index
format: xlsx
duration: 341.732666
Total allocated: 10.49 GB (80210986 objects)
Total retained: 274.44 MB (2887910 objects)
This Excel download is so slow, because it produces one Excel file with many sheets inside (tabs).
Produce each sheet for entity seperately
We could just as well produce each sheet in that excel separately into a file for each first, and then zip them into one sheet afterwards.
SQL query optimizations
Plus some query optimizations using .eager_load
or .includes
and done as an active job, I'm sure this coplaner excel can be optimized to work with Heroku.
Edited by Beat Seeliger