MySQL Forums
Forum List  »  Performance

Need to faster INSERTS
Posted by: Anders Holm
Date: April 14, 2008 07:49AM

Hi

I tried using Oracle DB for high speed inserts with Java. I can get up to 40,000 inserts per second using prepared statement and batch update. With mysql I only get about 3,000 inserts per second with the same method. Is there any other way to get faster inserts with mysql? Is there any other interface that can be used. I will mostly run the DB locally on the PCs.

/Anders Holm

Options: ReplyQuote


Subject
Views
Written By
Posted
Need to faster INSERTS
2644
April 14, 2008 07:49AM
1446
April 20, 2008 05:03AM


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.