Need to faster INSERTS
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
Subject
Views
Written By
Posted
Need to faster INSERTS
2715
April 14, 2008 07:49AM
1480
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.