cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Evans (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-3634) compare string vs. binary prepared statement parameters
Date Fri, 23 Dec 2011 21:46:31 GMT

    [ 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

        

Mime
View raw message