Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jakers@gmail.com designates
 209.85.210.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKkz8Q1czKCHrGGm6=hfBZYX5Unqqr1z0hjMngYjZB+cYJZpWQ@mail.gmail.com>
References: 
 <CAL35Oi1ZogQhJc8VPGR2L=oDoFJtLxtvE6cmr9JMXEpUOn316w@mail.gmail.com>
 <CAL35Oi0k-g5ONjys3bJi6RxiTpSqc0QrN62fR8xtRRJFR2ftBg@mail.gmail.com>
 <CALTRSKmezWi=w18fiQZc1m3p1ENuSennnDpT3s89Aym-oh30uA@mail.gmail.com>
 <CAAam9ssTjeX+C-3cMtWLRaL5ACerWmHU5fTZ9k5PtCSar3RTtw@mail.gmail.com>
 <CALdd-zhk7j+LYcouaLLnrx-X3soR2GfcCHnNgb8Hcmd2GHPyEQ@mail.gmail.com>
 <CAKkz8Q1czKCHrGGm6=hfBZYX5Unqqr1z0hjMngYjZB+cYJZpWQ@mail.gmail.com>
From: Jake Luciani <jakers@gmail.com>
Date: Fri, 13 Jan 2012 11:53:18 -0500
Message-ID: 
 <CALamADLodCxbizVpbAN1ffc-36f3WZ9qVNZM2MQ8iHDDcWzd1A@mail.gmail.com>
Subject: Re: Prepared Statement support (CASSANDRA-2475)
To: dev@cassandra.apache.org
Content-Type: multipart/alternative; boundary=f46d040f9b98e0753a04b66bb4ca

--f46d040f9b98e0753a04b66bb4ca
Content-Type: text/plain; charset=ISO-8859-1

Not to mention in the case of CFS we deal only in binary blobs.

I'd rather see us add a hex hack for JS and PHP rather then cater to them.

-Jake

On Fri, Jan 13, 2012 at 11:42 AM, Sylvain Lebresne <sylvain@datastax.com>wrote:

> I think CQL has a problem, it doesn't deal with binary correctly.
> I have very successfully used C* to store big amounts of small
> pictures and CQL just cannot handle that efficiently.
>
> I've looked quickly but I didn't see anywhere in the tests on
> CASSANDRA-3634 biggish column values tested (say in the order of 2-3
> digits of KB). I'm willing to bet that with that, the difference is
> not 10%, because there is the time to serialize/deserialize to string,
> but also the exploded size of binary represented as hex strings.
>
> I think prepared statement are a very good candidate to solve that
> 'handling binary correctly' problem, but only if we use binary for it.
> To me that is *very* big argument against Strings. Sure we could add
> yet another feature (or some hack) to handle binary, but why bother
> when prepared statement with binary gives us that *and* we get 10%
> faster writes even for small values.
>
> --
> Sylvain
>
>
> On Fri, Jan 13, 2012 at 5:01 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
> > On Fri, Jan 13, 2012 at 9:45 AM, Tyler Hobbs <tyler@datastax.com> wrote:
> >> On Fri, Jan 13, 2012 at 8:11 AM, Gary Dusbabek <gdusbabek@gmail.com>
> wrote:
> >>
> >>>
> >>> Not all languages <cough>Javascript</cough> make it easy to do binary.
> >>
> >>
> >> PHP also goes in this boat, which leads me to agree with Gary.
> >
> > I don't get it.  Don't you already have the binary encoding done for
> > the PHPCassa?
> >
> > --
> > Jonathan Ellis
> > Project Chair, Apache Cassandra
> > co-founder of DataStax, the source for professional Cassandra support
> > http://www.datastax.com
>


-- 
http://twitter.com/tjake

--f46d040f9b98e0753a04b66bb4ca--