Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of kosciak1@gmail.com designates
 209.85.220.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=U5bvLxKLExp8DjLoSRss3IyvbRVQr5D0CQDYdR9mnzDy/puRivHlRjDNHU/MCiF5I3
         IcMyieXY9CazTrvb5TfMh2Y2SqEUuGJ9DMqd3tIjqKz5kgiH8UsJZOPq+4Ez6Y50wZuL
         OGjAq5EKl8E2x6pMAb6VYRl/VP7rDcIZqLmSw=
MIME-Version: 1.0
From: Wojciech Pietrzok <kosciak1@gmail.com>
Date: Mon, 20 Jun 2011 23:04:52 +0200
Message-ID: <BANLkTinHg0r8CSzHzAYOKOwB=Nd-X6KFOw@mail.gmail.com>
Subject: Secondary indexes performance
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I've noticed that queries using secondary indexes seems to be getting
rather slow.
Right now I've got an Column Family with 4 indexed columns (plus 5-6
non indexed columns, column values are small), and around 1,5-2
millions of rows. I'm using pycassa client and query using
get_indexed_slices method that returns over 10k rows (in batches of
1024 rows) can take up to 30 seconds. Is it normal? Seems too long for
me.

Maybe there's a way to tune Cassandra config for better secondary
indexes performance?

Using Cassandra 0.7.6

-- 
KosciaK