[
https://issues.apache.org/jira/browse/CASSANDRA-3634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13175733#comment-13175733
]
Eric Evans commented on CASSANDRA-3634:
---------------------------------------
bq. Let's get Brandon to do some testing on our cluster with separate clients
and servers.
I've started another run with one client, one server, but having another set of
results would be great, thanks.
bq. If strings are testing faster than binary then either
I don't think strings are faster. The differences between String and BB for
the insert-with-index, counter-increment, and read tests are very small, (i.e.
we're looking at #2 here).
I believe the reason the insert-with-index and counter increment tests would
fail to show a significant difference is because those operations push the
contention needle in a different direction. This is consistent with the fact
that vanilla CQL fares so much better against thrift on these tests. Also, the
counter increment test only has one bind var (the key), so I would expect the
difference to be quite small.
Like the counter increment test, the read test also only has one bind var
(again the key), so I would likewise expect any difference to be lost in the
noise.
The insert test above _does_ indicate some difference, BB beats out Strings by
4% (5 columns equates to 11 bind vars here). I don't have the results in front
of me, but I ran a new insert test last night and I believe this increases to
about 10% at 10x the number of columns.
The choice of initial tests here were based on what I had run earlier (to make
the obligatory before/after comparison). Those are still relevant I think, but
to get a better idea of BB vs String, we need some results for insert tests
with higher column counts (w/ client and server split to rule out #3 above).
> 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
