Slow-down when creating many records in the console

Hi there,

I have a script I run through console to populate my forum application with random test data. It is supposed to create thousands of forum posts with several comments per post. The method essentially looks like this:

forum = Forums.create 2000.times do   forum.posts.create end

I've found that it slows to a near halt after it adds a few hundred messages. What is happening here? Is there something I can do to keep the thing moving quickly?

Thanks,

Andrew

andrewdmason@gmail.com wrote:

I have a script I run through console to populate my forum application with random test data. It is supposed to create thousands of forum posts with several comments per post. The method essentially looks like this:

forum = Forums.create 2000.times do   forum.posts.create end

I've found that it slows to a near halt after it adds a few hundred messages. What is happening here? Is there something I can do to keep the thing moving quickly?

Perhaps

2000.times do |i|    forum.posts.create    GC.start if i % 100 == 99 end

Can you be more specific as to what your code is doing? 'essentially' doesn't help to debug as I can write a quick test to do what you posted and it takes not time at all to insert 2000 records.

Chris