MySQL Forums
Forum List  »  GIS

Re: very slow insert, very large iowait
Posted by: Tom Nordgren
Date: March 27, 2009 08:22AM

I have the same problem. Insert into's are painfully slow. I do not have spatial indexes and have removed all indexes from tables. I am using INNODB and frequently get the dreaded too many locks error. If I import as a CSV using the mysqlimport the files take under 2 minutes. When I then insert from my staging tables to live it takes over 2 hours.
I can do the same insert into's in SQL Server in 4 minutes. But I am stuck with MySQL for this project.

Options: ReplyQuote

Written By
June 10, 2005 12:10PM
November 25, 2005 09:35AM
Re: very slow insert, very large iowait
March 27, 2009 08:22AM

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.