mysql - rails large amount of data in single insert activerecord gave out -


So I think I just want to be safe around 36,000, I think a bigger for a modern SQL MySQL like database will not have just two attributes in each record.

So I do: So I collected them in one of the included statements

  sql = "Enter into functions (attrib_a, attrib_b) value (C1, D1 ), (C2, D2), (C3, D3) ... (c36000, d36000); "ActiveRecord :: Base.connection.execute from sql to C: /Ruby/lib/ruby/gems/1.8/ Gems / activerecord-2.3.5 / lib / active_record / connection_adapters / abstract_adapter.rb: 219: in `logs' from C: /Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ Connection_adapters / mysql_adapter.rb: 323: c: / r / projects / vendor / plugins / rail-footnotes, execute_without_analyzer / lib / rails-footnotes / notes / queries_note.rb: 130: 'executed' with C: / ruby ​​/ lib /ruby/1.8/benchmark.rb: 308: `Real C: / r / projects / vendor / plugins / rails-footnotes / lib / rails-footnotes / notes / queries_note.rb: Time of '130: Out of (`irb)' execute: 53 to C: / Ruby / lib /ruby/gems/1.8/gems/activesupport-2.3. 5 / lib / active_support / vendor / tzinfo-0.3.12 / tzinfo / time_or_datetime.rb: 242  

I do not know the above information is sufficient, please ask anything I did not give here So what was this about any idea?

Thank you!

The problem is due to time I had the same problem, while using the theory ORM In php we can solve this problem by changing the time of script in php.ini file. But I do not know how the number can change in the train. Here may be something that will help you ..


Comments