Exporting significant SQL reports with ActiveRecord

A few months ago we faced a memory issue on some of our background jobs. Heroku was killing our dyno because it was exceeding its allowed memory. Thanks to our instrumentation of Sidekiq, it was easy to spot the culprit. The job was doing a fairly complex SQL request, and outputing the query’s result into a CSV file before archiving this file.
Exporting significant SQL reports with ActiveRecord #ruby #rubydeveloper #rubyonrails #activerecord #sql https://rubyonrails.ba/single/exporting-significant-sql-reports-with-activerecord

Nezir Zahirovic

Contractor Ruby On Rails (8+ years) / MCPD .Net / C# / Asp.Net / CSS / SQL / (11 years)

related articles