I was trying to update around 4000 records in a ruby migration script. It had taken a few minutes on my local laptop (a G4), but after it had run for an hour on DreamHost and only updated 200 of the records, I decided to give up. I had made a dump before I did the update, so now I'm trying to restore that dump and it has been running for over half an hour. The dump is about 3.4 meg and took about 10 minutes to restore on my laptop. I also loaded the same dump on another hosting service and it took 25 seconds.
Any ideas about what's taking it so long? Any suggestions on how to speed things up?