MySQL Forums :: Data Warehouse :: Slow Inserts

Advanced Search

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

Subject Views Written By Posted
Slow Inserts 10368 Nathan Whitworth 10/03/2008 09:03AM
Re: Slow Inserts 5485 Vince Gatto 10/03/2008 10:12AM
Re: Slow Inserts 4942 Tom Nordgren 03/27/2009 08:25AM
Re: Slow Inserts 4958 Rick James 03/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.