Database optimization?

Question

Ruby on Rails

Hello. How correct is the approach to move away from interacting with the model and switch to manual query generation. I have large data arrays being transferred, but Active Record inserts only one record at a time, and at the same time, with each insert, there is a request for all subordinate tables, so the place of one insert can go 5 Select to the subordinate tables and the insert itself. With more than 5000 entries, there is already a noticeable delay time. Slowly all on manual insertion directly. How true is all this, and what problems, besides referential integrity, can I remove. Thank you.

ts_data.each { | ts |
              sql_values += ",(#{ id }," +
                            "#{ children_groups[ ts[ :children_group_code ] ] }," +
                            "#{ children[ ts[ :child_code ] ] }," +
                            "#{ reasons_absences[ ts[ :reasons_absence_code ] ] }," +
                            "'#{ ts[ :date ] }'," +
                            "'#{ now }','#{ now }')"
            }

            sql = "INSERT INTO timesheet_dates ( #{ fields } ) VALUES #{ sql_values[1..-1] }"

            ActiveRecord::Base.connection.execute( sql )
end

Answer 1

There is bulk_insert and activerecord-import