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 jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=cfP6aGklu9iO/9u7x2Z5HtUa99H/lCvGGbo55C0T2YluRkFcBiEBYkky1aFihN4Izr
         FUJR5bF8uwg6cgc+cwrNWcgLAN+K51Bo28xpKXEaEjfAOgQtxlk7imeDx94y7ixqgts4
         UzZFppRDbhdkXKlYkEIBACWBiV7shZ6+mY65w=
MIME-Version: 1.0
In-Reply-To: <v2n1ab2da821004131100q5d4996b0ncfc4604b255b0f97@mail.gmail.com>
References: <v2n1ab2da821004131100q5d4996b0ncfc4604b255b0f97@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Wed, 14 Apr 2010 09:45:10 -0500
Message-ID: <i2xe06563881004140745g798010c1s7f3404aeea3e8e32@mail.gmail.com>
Subject: Re: Reading thousands of columns
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

35-50ms for how many rows of 1000 columns each?

get_range_slices does not use the row cache, for the same reason that
oracle doesn't cache tuples from sequential scans -- blowing away
1000s of rows worth of recently used rows queried by key, for a swath
of rows from the scan, is the wrong call more often than it is the
right one.

On Tue, Apr 13, 2010 at 1:00 PM, James Golick <jamesgolick@gmail.com> wrote:
> Hi All,
> I'm seeing about 35-50ms to read 1000 columns from a CF using
> get_range_slices. The columns are TimeUUIDType with empty values.
> The row cache is enabled and I'm running the query 500 times in a row, so I
> can only assume the row is cached.
> Is that about what's expected or am I doing something wrong? (It's from java
> this time, so it's not ruby thrift being slow).
> - James