# app/controllers/admin/submissions_controller.rb:238-267
def get_feed_data(days_limit)
 all_question_responses = []
 Form.all.each do |form| # Problem 1: Loads ALL forms into memory
 submissions = form.submissions.ordered # Problem 2: N+1 query per form
 submissions = submissions.where('created_at >= ?', days_limit.days.ago) if days_limit.positive?
 submissions.each do |submission| # Problem 3: Loads ALL submissions per form
 form.ordered_questions.each do |question| # Problem 4: N+1 query per submission
 question_text = question.text.to_s
 answer_text = Logstop.scrub(submission.send(question.answer_field.to_sym).to_s)
 @hash = {
 organization_id: form.organization_id,
 organization_name: form.organization.name, # Problem 5: N+1 for organization
 form_id: form.id,
 form_name: form.name,
 submission_id: submission.id,
 question_id: question.id,
 user_id: submission.user_id,
 question_text:,
 response_text: answer_text,
 question_with_response_text: "#{question_text}: #{answer_text}",
 created_at: submission.created_at,
 }
 all_question_responses << @hash # Problem 6: Unbounded array growth
 end
 end
 end
 all_question_responses # Problem 7: Returns massive array
end

# app/controllers/admin/submissions_controller.rb
def get_feed_data(days_limit)
 Enumerator.new do |yielder|
 # Batch forms with eager loading
 Form.includes(:organization, :questions)
 .find_each(batch_size: 100) do |form|
 # Build submissions query with date filter
 submissions_scope = form.submissions
 submissions_scope = submissions_scope.where('created_at >= ?', days_limit.days.ago) if days_limit.positive?
 # Batch submissions
 submissions_scope.find_each(batch_size: 1000) do |submission|
 # Questions already eager loaded
 form.questions.each do |question|
 question_text = question.text.to_s
 answer_text = Logstop.scrub(submission.send(question.answer_field.to_sym).to_s)
 yielder << {
 organization_id: form.organization_id,
 organization_name: form.organization.name,
 form_id: form.id,
 form_name: form.name,
 submission_id: submission.id,
 question_id: question.id,
 user_id: submission.user_id,
 question_text: question_text,
 response_text: answer_text,
 question_with_response_text: "#{question_text}: #{answer_text}",
 created_at: submission.created_at,
 }
 end
 end
 end
 end
end
# Update export_feed to stream the response
def export_feed
 @days_limit = (params[:days_limit].present? ? params[:days_limit].to_i : 1)
 respond_to do |format|
 format.csv do
 headers['Content-Type'] = 'text/csv; charset=utf-8'
 headers['Content-Disposition'] = "attachment; filename=touchpoints-feed-#{Date.today}.csv"
 headers['X-Accel-Buffering'] = 'no' # Disable nginx/proxy buffering
 headers['Cache-Control'] = 'no-cache'
 self.response_body = StreamingCsvExporter.new(get_feed_data(@days_limit))
 end
 format.json do
 # For JSON, consider pagination or background job for large datasets
 render json: get_feed_data(@days_limit).take(10_000).to_a
 end
 end
end

# app/services/streaming_csv_exporter.rb
class StreamingCsvExporter
 HEADERS = %w[
 organization_id organization_name form_id form_name submission_id
 question_id user_id question_text response_text
 question_with_response_text created_at
 ].freeze
 def initialize(enumerator)
 @enumerator = enumerator
 end
 def each
 yield CSV.generate_line(HEADERS)
 @enumerator.each do |row|
 yield CSV.generate_line(HEADERS.map { |h| row[h.to_sym] })
 end
 end
end

# app/jobs/feed_export_job.rb
class FeedExportJob < ApplicationJob
 queue_as :exports
 def perform(user_email, days_limit)
 file_path = Rails.root.join('tmp', "feed-export-#{SecureRandom.uuid}.csv")
 CSV.open(file_path, 'wb') do |csv|
 csv << StreamingCsvExporter::HEADERS
 Form.includes(:organization, :questions).find_each(batch_size: 100) do |form|
 # ... batched processing, write directly to file
 end
 end
 # Upload to S3 and email user
 url = S3Uploader.upload(file_path)
 UserMailer.export_ready(user_email, url).deliver_later
 ensure
 FileUtils.rm_f(file_path)
 end
end