MySQL Forums
Forum List  »  Data Warehouse

Re: Slow Inserts
Posted by: Tom Nordgren
Date: March 27, 2009 08:25AM

I have the same problem. Bulk inserts take 2-3 minutes into my staging tables, But then I do insert into's for production. And the same tables take 2ish hours. I had thought of moving to MyISAM - apparently that won't solve the issue?
I may import to staging, Modify what I need, Export to CSV, then bulk load back to production. WHAT A PAIN.

Options: ReplyQuote

Written By
October 03, 2008 09:03AM
October 03, 2008 10:12AM
Re: Slow Inserts
March 27, 2009 08:25AM
March 27, 2009 09:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.