Skip navigation links

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 9068 Nathan Whitworth 10/03/2008 09:03AM
Re: Slow Inserts 4937 Vince Gatto 10/03/2008 10:12AM
Re: Slow Inserts 4396 Tom Nordgren 03/27/2009 08:25AM
Re: Slow Inserts 4435 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.