MySQL Forums :: Data Warehouse :: Slow Inserts
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.
I may import to staging, Modify what I need, Export to CSV, then bulk load back to production. WHAT A PAIN.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Slow Inserts | 7870 | Nathan Whitworth | 10/03/2008 09:03AM |
| Re: Slow Inserts | 4368 | Vince Gatto | 10/03/2008 10:12AM |
| Re: Slow Inserts | 3782 | Tom Nordgren | 03/27/2009 08:25AM |
| Re: Slow Inserts | 3868 | 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.
© 2013, Oracle Corporation and/or its affiliates