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: domain of augustyn.michal@gmail.com
 designates 209.85.216.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=pO07E6/xvyJ91J9suE/SdtqqCQKZHZxH32ydUVwSTH+UQNTgBNdxohWs98fEspCooR
         NL2Pnws1JQVq2HT5IjDt7djghHCud/tW+uZEp+Q6m4x9DiWwOFh1U7fOscFyZ8ikRpDh
         bFGeb25S6IlgYYioofHjfG+FE2EYe3CNgOeis=
MIME-Version: 1.0
Date: Sun, 5 Sep 2010 12:39:30 +0200
Message-ID: <AANLkTi=CTtigBCSOoNvbUK2GFR=GO4pkrVFCi8iup5-r@mail.gmail.com>
Subject: skip + limit support in GetSlice
From: =?ISO-8859-1?Q?Michal_August=FDn?= <augustyn.michal@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016e64bb7c2642b74048f80c749

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

Hello,

probably this is feature request. Simply, I would like to have support for
standard pagination (skip + limit) in GetSlice Thrift method. Is this
feature on the road map?

Now, I have to perform GetSlice call, that starts on "" and "limit" is set
to "skip" value. Then I read the last column name returned and subsequently
perform the final GetSlice call - I use the last column name as "start" and
set "limit" to "limit" value.

This workaround is not very efficient when I need to skip a lot of columns
(so "skip" is high) - then a lot of data must be transferred via network. So
I think that support for Skip in GetSlice would be very useful (to avoid
high network traffic).

The implementation could be very straightforward (same as the workaround) or
maybe it could be more efficient - I think that whole row (so all columns)
must fit into memory so if we have all columns in memory...

Thank you!

Augi

--0016e64bb7c2642b74048f80c749
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<span class=3D"Apple-style-span" style=3D"font-family: arial, sans-serif; f=
ont-size: 13px; border-collapse: collapse; ">Hello,<div><br></div><div>prob=
ably this is feature request. Simply, I would like to have support for stan=
dard pagination (skip + limit) in GetSlice Thrift method. Is this feature o=
n the road map?</div>
<div><br></div><div>Now, I have to perform GetSlice call, that starts on &q=
uot;&quot; and &quot;limit&quot; is set to &quot;skip&quot; value. Then I r=
ead the last column name returned and subsequently perform the final GetSli=
ce call - I use the last column name as &quot;start&quot; and set &quot;lim=
it&quot; to &quot;limit&quot; value.</div>
<div><br></div><div>This workaround is not very efficient when I need to sk=
ip a lot of columns (so &quot;skip&quot; is high) - then a lot of data must=
 be=A0transferred=A0via network. So I think that support for Skip in GetSli=
ce would be very=A0useful (to avoid high network=A0traffic).</div>
<div><br></div><div>The implementation could be very=A0straightforward=A0(s=
ame as the workaround) or maybe it could be more efficient - I think that w=
hole row (so all columns) must fit into memory so if we have all columns in=
 memory...</div>
<div><br></div><div>Thank you!</div><div><br></div><div>Augi</div></span>

--0016e64bb7c2642b74048f80c749--