From: Nic Xie <yudora111@...>
Date: 2009-01-20T03:20:55+09:00
Subject: migration too slow?

I have a migration including a update_all statement to a big
table(having 100K+ rows).

It gets too slow. It has been running for 8 hours and not done yet. I
don't know if it is still running.
Any one can give me some food for thought?
I tried to use --trace to keep track of the migration. But it doesn't
give me enough info. I still don't know if that update_all statement is
running or dead.

My migration is like this:
 def self.up
    add_column :x_logs, :x_type, :string
    rename_column :x_logs, :y_id, :z_id
    XLog.update_all("x_type = 'blah'")

 end


Thanks in advance.
-- 
Posted via http://www.ruby-forum.com/.