Non prepared vs Prepared using cassandra-stress tool

gistfile1.txt

XXXX@XXXXXXXXX:~$ cassandra-stress --enable-cql3 --nodes=10.0.0.110,10.0.64.110,10.0.128.110 --enable-native-protocol --replication-factor=3 --random
15/03/27 12:52:57 INFO snitch.Workload: Setting my workload to Cassandra
Created keyspaces. Sleeping 3s for propagation.
total,interval_op_rate,interval_key_rate,latency,95th,99.9th,elapsed_time
49375,4937,4937,1.9,7.4,42.0,10
125611,7623,7623,2.1,5.6,223.1,20
196616,7100,7100,2.0,5.4,23.6,30
272025,7540,7540,2.0,5.5,585.4,40
341899,6987,6987,2.0,5.5,323.6,50
420685,7878,7878,2.1,5.5,323.1,61
495913,7522,7522,2.1,5.5,18.4,71
569249,7333,7333,2.2,5.2,18.4,81
645093,7584,7584,2.3,5.4,18.4,91
718506,7341,7341,2.4,5.4,265.0,101
791404,7289,7289,2.4,5.5,265.0,112
861924,7052,7052,2.4,5.6,18.4,122
933923,7199,7199,2.4,5.6,18.1,132
997361,6343,6343,2.4,5.5,18.1,142
1000000,263,263,2.4,5.5,18.1,143


Averages from the middle 80% of values:
interval_op_rate          : 7386
interval_key_rate         : 7386
latency median            : 2.2
latency 95th percentile   : 5.5
latency 99.9th percentile : 189.3
Total operation time      : 00:02:23
END



XXXX@XXXXXXXXX:~$ cassandra-stress --enable-cql3 --nodes=10.0.0.110,10.0.64.110,10.0.128.110 --enable-native-protocol --replication-factor=3 --random --use-prepared-statements
15/03/27 12:58:41 INFO snitch.Workload: Setting my workload to Cassandra
Created keyspaces. Sleeping 3s for propagation.
total,interval_op_rate,interval_key_rate,latency,95th,99.9th,elapsed_time
35360,3536,3536,1.8,12.6,125.4,10
110567,7520,7520,1.9,8.9,464.1,20
186815,7624,7624,1.8,6.6,333.4,30
267559,8074,8074,1.9,6.1,324.9,40
333459,6590,6590,2.0,6.1,324.8,51
399790,6633,6633,1.9,5.7,324.8,61
468044,6825,6825,1.9,5.6,324.8,71
524531,5648,5648,1.9,5.7,328.5,81
589798,6526,6526,1.8,5.2,331.9,91
656377,6657,6657,1.8,5.0,331.9,102
726805,7042,7042,1.8,4.9,324.4,112
802825,7602,7602,1.8,5.5,324.4,122
875031,7220,7220,1.8,5.4,27.9,132
942702,6767,6767,1.9,5.7,20.9,142
1000000,5729,5729,1.9,5.7,20.9,152


Averages from the middle 80% of values:
interval_op_rate          : 6996
interval_key_rate         : 6996
latency median            : 1.9
latency 95th percentile   : 5.9
latency 99.9th percentile : 313.8
Total operation time      : 00:02:32
END