MySQL Forums
Forum List  »  Quality Assurance

ClusterJ and jdbc comparision
Posted by: nihasmata nihasmata
Date: August 15, 2012 09:00AM

I am using Mysql Cluster 7.1.10. In common consent,clusterj performance is better than jdbc. When i compared them, i see that jdbc performance is better in many test.I tested like below;

1-) I inserted 1 million records in database,Clusterj inserts 10000 records in 146 second, but jdbc inserts 10000 in 35 seconds

2-) I used select clause,ClusterJ selects 100000 records 11,8 seconds,200000 records in 18 seconds,but jdbc selects 100000 records in 3.3 seconds and 200000 records in 10.5 seconds

3-) When i used 20000 records per transaction for insertion, clusterj inserts 1 million records in 128 seconds, but jdbc inserts 1 million records in 2800 seconds.

My questions are that;

1-) Why jdbc performance is better than clusterj except using transaction.

2-) I think i am missing sometthing,because clusterj performance must be better than jdbc according to mysql ?

Options: ReplyQuote

Written By
ClusterJ and jdbc comparision
August 15, 2012 09:00AM

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.