Re: Using DISABLE KEYS on production tables

[Dave Scofield]

Thanks, Rick.

Good to hear that my uneasiness about DISABLE KEYS wasn't totally unfounded.

I like the idea of breaking up the inserts into groups. I have done some testing locally, but not on the production machine. On my dev box (wamp) it takes about 1 second per 1000 rows, so i definitely want to break it up. (It's actually a several inserts into multiple tables after doing lookups on some values, yadda, yadda.)

I also have to watch out for the application timing out (php). This is heavily date-based data, so I think what I'm gonna do is make the customer pick the year they want to migrate, and then click start. Then I'll do each month in one pass, and sleep between each month. This will break it up into much more manageable chunks, each taking a reasonable amount of time, hopefully. Then the UI will come back and let them pick another year.

Thanks again for the reply. The article was helpful, and will work great as a starting point.