MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Where does the time go?
Posted by: Boris Burtin
Date: October 26, 2005 05:29PM

A large number of small operations will be slower than a single bulk load. Can you use LOAD DATA INFILE? Not sure if it will work with your auto-increment column, but it's worth looking into. If not, you could drop your unique index before the inserts and recreate it at the end.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Where does the time go?
2078
Mark Modrall
September 30, 2005 03:52PM
Re: Where does the time go?
1315
KimSeong Loh
October 02, 2005 06:34PM
Re: Where does the time go?
1434
Mark Modrall
October 03, 2005 11:24AM
Re: Where does the time go?
1336
Boris Burtin
October 26, 2005 05:29PM
Re: Where does the time go?
1315
Mark Modrall
October 26, 2005 07:21PM
Re: Where does the time go?
1351
Boris Burtin
October 31, 2005 01:47PM


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.