Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <521DD86D.8070903@iconplatforms.com>
Date: Wed, 28 Aug 2013 14:01:01 +0300
From: Vassilis Bekiaris <bekiarisv@iconplatforms.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8;
 rv:17.0) Gecko/20130801 Thunderbird/17.0.8
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: CQL: Prepared statements
References: 
 <CACb9f-8NQ7qnRCCruen6WezRbMCvb2SvVQC=MQvbxJjAq==gOA@mail.gmail.com>
In-Reply-To: 
 <CACb9f-8NQ7qnRCCruen6WezRbMCvb2SvVQC=MQvbxJjAq==gOA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------030008050300000706090509"
'X-AV-Checked: ClamAV using ClamSMTP'
X-Virus-Checked: Checked by ClamAV on apache.org

This is a multi-part message in MIME format.
--------------030008050300000706090509
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi,

I think the introductory paragraphs in the Java Driver documentation [1]
provide good justification on the use of prepared statements:

" ... but you can also use prepared statements, which only need to be
parsed once by the cluster, and then bind values to the variables and
execute the bound statement you read or write data to a cluster.

In the previous tutorial, you added a loadData method which creates a
new statement for each INSERT, but you may also use prepared statements
and bind new values to the columns each time before execution. Doing
this increases performance, especially for repeated queries."

Cheers!

[1]
http://www.datastax.com/documentation/developer/java-driver/1.0/webhelp/index.html#java-driver/quick_start/qsSimpleClientBoundStatements_t.html

On 28/8/13 13:45 , Jorge Bay Gondra wrote:
> Hi,
>
> I'm developing the Node.js CQL Driver
> <https://github.com/jorgebay/node-cassandra-cql> and I've just
> finished implementing prepared statements through the binary protocol... 
>
> I would like to provide driver users some guidance (use prepared
> queries when X / use normal queries when Y): Is there any good user
> documentation on prepared statements that I could point to?
>
> For me, I would recommend prepared statements because parameters are
> binary encoded instead of being "stringified" as it happends while
> executing a regular query. This is specially correct when dealing with
> blobs and other binary data (blob bytes -> string -> bytes). 
>
> Thanks,
> J


--------------030008050300000706090509
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi,<br>
      <br>
      I think the introductory paragraphs in the Java Driver
      documentation [1] provide good justification on the use of
      prepared statements:<br>
      <br>
      "
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      ... but you can also use prepared statements, which only need to
      be parsed once by the cluster, and then bind values to the
      variables and execute the bound statement you read or write data
      to a cluster.<br>
      <br>
      In the previous tutorial, you added a loadData method which
      creates a new statement for each INSERT, but you may also use
      prepared statements and bind new values to the columns each time
      before execution. Doing this increases performance, especially for
      repeated queries."<br>
      <br>
      Cheers!<br>
      <br>
      [1]
<a class="moz-txt-link-freetext" href="http://www.datastax.com/documentation/developer/java-driver/1.0/webhelp/index.html#java-driver/quick_start/qsSimpleClientBoundStatements_t.html">http://www.datastax.com/documentation/developer/java-driver/1.0/webhelp/index.html#java-driver/quick_start/qsSimpleClientBoundStatements_t.html</a><br>
      <br>
      On 28/8/13 13:45 , Jorge Bay Gondra wrote:<br>
    </div>
    <blockquote
cite="mid:CACb9f-8NQ7qnRCCruen6WezRbMCvb2SvVQC=MQvbxJjAq==gOA@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hi,
        <div><br>
          I'm developing the <a moz-do-not-send="true"
            href="https://github.com/jorgebay/node-cassandra-cql">Node.js
            CQL Driver</a> and I've just finished implementing prepared
          statements through the binary protocol... </div>
        <div><br>
        </div>
        <div>I would like to provide driver users some guidance (use
          prepared queries when X / use normal queries when Y): Is there
          any good user documentation on prepared statements that I
          could point to?</div>
        <div>
          <br>
        </div>
        <div>For me, I would recommend prepared statements because
          parameters are binary encoded instead of being "stringified"
          as it happends while executing a regular query. This is
          specially correct when dealing with blobs and other binary
          data (blob bytes -&gt; string -&gt; bytes). <br>
        </div>
        <div><br>
        </div>
        <div>Thanks,</div>
        <div>J</div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------030008050300000706090509--