On Fri, Mar 26, 2010 at 14:47, Jonathan Ellis jbel...@gmail.com wrote:
On Fri, Mar 26, 2010 at 7:40 AM, Henrik Schröder skro...@gmail.com
wrote:
For each indexvalue we insert a row where the key is indexid + : +
indexvalue encoded as hex string, and the row contains only one column,
where
On Mon, Mar 29, 2010 at 4:06 AM, Henrik Schröder skro...@gmail.com wrote:
On Fri, Mar 26, 2010 at 14:47, Jonathan Ellis jbel...@gmail.com wrote:
It's a unique index then? And you're trying to read things ordered by
the index, not just give me keys with that have a column with this
value?
So all the values for an entire index will be in one row? That
doesn't sound good.
You really want to put each index [and each table] in its own CF, but
until we can do that dynamically (0.7) you could at least make the
index row keys a tuple of (indexid, indexvalue) and the column names
On Fri, Mar 26, 2010 at 7:40 AM, Henrik Schröder skro...@gmail.com wrote:
For each indexvalue we insert a row where the key is indexid + : +
indexvalue encoded as hex string, and the row contains only one column,
where the name is the object key encoded as a bytearray, and the value is
empty.
I don't know If that could play any role, but if ever you have
disabled the assertions
when running cassandra (that is, you removed the -ea line in
cassandra.in.sh), there
was a bug in 0.6beta2 that will make read in row with lots of columns
quite slow.
Another problem you may have is if you have
On Thu, Mar 25, 2010 at 15:17, Sylvain Lebresne sylv...@yakaz.com wrote:
I don't know If that could play any role, but if ever you have
disabled the assertions
when running cassandra (that is, you removed the -ea line in
cassandra.in.sh), there
was a bug in 0.6beta2 that will make read in
I noticed you turned Key caching off in your ColumnFamily declaration,
have you tried experimenting with this on and playing key caching
configuration? Also, have you looked at the JMX output for what
commands are pending execution? That is always helpful to me in
hunting down bottlenecks.
-Nate
On Thu, Mar 25, 2010 at 5:31 PM, Henrik Schröder skro...@gmail.com wrote:
On Thu, Mar 25, 2010 at 15:17, Sylvain Lebresne sylv...@yakaz.com wrote:
I don't know If that could play any role, but if ever you have
disabled the assertions
when running cassandra (that is, you removed the -ea line
On Thu, Mar 25, 2010 at 8:33 AM, Henrik Schröder skro...@gmail.com wrote:
Hi everyone,
We're trying to implement a virtual datastore for our users where they can
set up tables and indexes to store objects and have them indexed on
arbitrary properties. And we did a test implementation for