[Ruby] Parallel migration

Michael Kreeger michael.kreeger at gmail.com
Fri Jan 19 12:22:33 PST 2007


Sounds like your going to be limited to the speed of the disk.
Parallel procs are great for number crunching but databases funnel
down to one table for writing otherwise there would be conflicts.

Am I thinking about this the right way?  Anyone?

Michael

On 1/19/07, Alex Vollmer <alex.vollmer at gmail.com> wrote:
> Okay, I've got a rather esoteric question about ActiveMigrations. Does
> anyone know of an existing solution to run parts of your migration in
> parallel? For example we have some ALTER TABLE commands that are changing
> the column type for some large tables. By default each ALTER command is
> executed one after the other which is pretty slow. But some of the tables
> aren't directly related to each other so it's possible to run the
> alterations in parallel to take advantage of the multiple procs on the DB
> server. I'm not sure I really want to do this, but I was curious if anyone
> knew anything about it.
>
> TIA,
>
> Alex V.
>
> --
> "I think there are only three things America will be known for 2,000 years
> from now when they study this civilization: the Constitution, jazz music,
> and baseball."
> --Gerald Early
> _______________________________________________
> Ruby at zenspider.com - Seattle.rb non-commercial list
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby
>


-- 
Michael Kreeger
Mobile: 425-445-2191
Skype: (425)296-6810


More information about the Ruby mailing list