[
https://issues.apache.org/jira/browse/CASSANDRA-3634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13175588#comment-13175588
]
Eric Evans commented on CASSANDRA-3634:
---------------------------------------
Here is the performance comparison. I stuck to the same tests I performed
earlier (those earlier results can be found
[here|http://www.acunu.com/blogs/eric-evans/cql-benchmarking]). The patches to
support binary query parameters for Cassandra and {{stress}} are attached to
this issue, and the raw results can be found [here|
http://people.apache.org/~eevans/3634].
_Note: Percentages listed are in relation to RPC performance._
h3. Inserts, 20M rows x 5 columns
!http://people.apache.org/~eevans/3634/insert_20mx5_noidx_t50_20111223.png|width=700!
|| ||Average OP rate||Average Latency||
|RPC|23,681/s|1.1ms|
|CQL|21,128/s (-11%)|1.3ms (+11%)|
|CQL w/ Prepared statements|23,911/s|1.1ms|
|CQL w/ Prepared statements (binary parms)|24,919/s (+5%)|1.2ms (+5%)|
h3. Inserts, 10M rows x 5 columns, KEYS index
!http://people.apache.org/~eevans/3634/insert_10mx5_keysidx_t50_20111223.png|width=700!
|| ||Average OP rate||Average Latency||
|RPC|10,054/s|5ms|
|CQL|9,326/s (-7%)|5.4ms (+8%)|
|CQL w/ Prepared statements|10,413/s (+3%)|4.8ms (-3%)|
|CQL w/ Prepared statements (binary parms)|10,299/s (+2%)|5ms|
h3. Counter increments, 10M rows x 5 columns
!http://people.apache.org/~eevans/3634/count_10mx5_noidx_t50_20111223.png|width=700!
|| ||Average OP rate||Average Latency||
|RPC|22,075/s|1.2ms|
|CQL|20,645/s (-6%)|1.2ms (+2%)|
|CQL w/ Prepared statements|24,286/s (+9%)|1.2ms (-1%)|
|CQL w/ Prepared statements (binary parms)|23,359/s (+5%)|1.2ms|
h3. Reads, 20M rows x 5 columns
!http://people.apache.org/~eevans/3634/read_20mx5_noidx_t50_20111223.png|width=700!
|| ||Average OP rate||Average Latency||
|RPC|22,285/s|2.1ms|
|CQL|20,080/s (-10%)|2.3ms (+9%)|
|CQL w/ Prepared statements|22,374/s|2.1ms (-1%)|
|CQL w/ Prepared statements (binary parms)|22,176/s|2.1ms|
> compare string vs. binary prepared statement parameters
> -------------------------------------------------------
>
> Key: CASSANDRA-3634
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3634
> Project: Cassandra
> Issue Type: Sub-task
> Components: API, Core
> Reporter: Eric Evans
> Assignee: Eric Evans
> Priority: Minor
> Labels: cql
> Fix For: 1.1
>
> Attachments: stress-change-bind-parms-to-BB.patch,
> v1-0001-CASSANDRA-3634-generated-thrift-code.txt,
> v1-0002-change-bind-parms-from-string-to-bytes.txt
>
>
> Perform benchmarks to compare the performance of string and pre-serialized
> binary parameters to prepared statements.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
