Frederick Cheung wrote:
> On May 10, 10:41�am, Jian Lin <[email protected]>
> wrote:
>> it actually force write to the physical disc?
> It's never that simple (and yes under the appropriate circumstances
> the drive is supposed to flush to the actual disk). For example
> there's a constant amount of overhead with each query: network latency
> etc. not a huge amount (probably less than a millisecond), but
> multiply that by 34000 and it will add up. If you really need to
> manipulate this much data you'd be well advised to do the inserts in
> bulk.
so how to do inserts in bulk? by using
Phrase.connection.execute("insert into phrases(s,frequency,length)
values('#{phrase}',#{frequencies[phrase]},#{lengths[phrase]})")
? or by ar-extensions? can ActiveRecord have a mode for saving without
being in a transaction, or can ActiveRecord has some standard method of
doing bulk inserts?
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
