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:
add_column :x_logs, :x_type, :string
rename_column :x_logs, :y_id, :z_id
XLog.update_all(“x_type = ‘blah’”)
Thanks in advance.