I have a table containing about 30k rows of data and there's several table associations. The problem is that there's like 18 columns, and each column requires 1 db query.
Here's an example of what I'm doing:
if col_num == 0
tmp_string_text = finding_phase
elsif col_num == 1
tmp_string_text = ""
elsif col_num == 2
tmp_string_text = ""
elsif col_num == 3
tmp_string_text = finding.vuln_finding.severity
elsif col_num == 4
tmp_string_text = finding.node.ip
elsif col_num == 5
tmp_string_text = finding.node.host_name
elsif col_num == 6
tmp_string_text = finding.node.dns_name
elsif col_num == 7
tmp_string_text = finding.port
elsif col_num == 8
tmp_string_text = finding.pentest_finding.name
elsif col_num == 9
tmp_string_text = finding.vuln_finding.name
elsif col_num == 10
tmp_string_text = finding.vuln_finding.description
elsif col_num == 11
tmp_string_text = finding.vuln_finding.solution
elsif col_num == 12
tmp_string_text = finding.additional_output
elsif col_num == 13
tmp_string_text = finding.cve
elsif col_num == 14
tmp_string_text = finding.node.os
elsif col_num == 15
tmp_string_text = finding.node.device_type
elsif col_num == 16
tmp_string_text = finding.node.scan_time
end
As a result, there's going to be 15 queries to the DB per 1 row. Is there any way that I can make this more efficient? This takes a REALLY long time when I have 30k rows. Not looking for anyone to flame here, just looking for advice. Pretty new to Ruby on Rails but learning as I go.
*** EDIT ***
So basicallyBasically, "finding" in this case is a result of @my_report.findings@my_report.findings and it's going through each finding and pulling back data.
