Ken Hancock wrote
> You didn't post any timings, only when it started failing so it's unclear
> whether performance is dropping off or scaling in some sort of linear or
> non-linear fashion. Second the recommendation to do some traces which
> should be much more telling.
I'm afraid I've not yet ha
You didn't post any timings, only when it started failing so it's unclear
whether performance is dropping off or scaling in some sort of linear or
non-linear fashion. Second the recommendation to do some traces which
should be much more telling.
On Fri, Jun 13, 2014 at 3:34 AM, Phil Luckhurst <
p
But would you expect performance to drop off so quickly? At 250,000 records
we can still page through the query with LIMIT 5 but when adding an
additional 50,000 records we can't page past the first 10,000 records even
if we drop to LIMIT 10.
What about the case where we add 100,000 records fo
On Thu, Jun 12, 2014 at 9:18 AM, Phil Luckhurst <
phil.luckhu...@powerassure.com> wrote:
> The problem appears to be directly related to number of entries in the
> index.
> I started with an empty table and added 50,000 entries at a time with the
> same indexed value.
All requests in Cassandra a
The problem appears to be directly related to number of entries in the index.
I started with an empty table and added 50,000 entries at a time with the
same indexed value. I was able to page through the results of a query that
used the secondary index with 250,000 records in the table using a LIMIT
On Wed, Jun 11, 2014 at 12:43 PM, Phil Luckhurst <
phil.luckhu...@powerassure.com> wrote:
> It just seems that what we are trying to do here is
> such basic functionality of an index that I thought we must be doing
> something wrong for it to appear to be this broken.
>
To be clear, I did not rea
Thanks Rob.
I understand that we will probably end up either creating our own index or
duplicating the data and we have done that to remove a reliance on secondary
indexes in other places. It just seems that what we are trying to do here is
such basic functionality of an index that I thought we mu
I like the "- Provides the illusion that you are using a RDBMS." part ;-)
On Wed, Jun 11, 2014 at 8:52 PM, Robert Coli wrote:
> On Wed, Jun 11, 2014 at 2:24 AM, Phil Luckhurst <
> phil.luckhu...@powerassure.com> wrote:
>
>> Is paging through the results of a secondary index query broken in
>> C
On Wed, Jun 11, 2014 at 2:24 AM, Phil Luckhurst <
phil.luckhu...@powerassure.com> wrote:
> Is paging through the results of a secondary index query broken in
> Cassandra
> 2.0.7 or are we doing something wrong?
>
General feedback on questions of this type :
http://mail-archives.apache.org/mod_mb
