Re: Indexes Fragmentation

2014-10-06 Thread Robert Coli
On Fri, Oct 3, 2014 at 6:03 PM, Arthur Zubarev wrote: > I now see I had misspelled the word tall for toll, anyways, if I > understood correctly, your reply implies there is no impact whatsoever and > there is no need to defrug indexes of the frequently changing columns. > "Cases with lots of sec

Re: Indexes Fragmentation

2014-10-03 Thread Arthur Zubarev
Original Message From: Robert Coli To: user Sent: Mon, Sep 29, 2014 8:01 pm Subject: Re: Indexes Fragmentation On Sun, Sep 28, 2014 at 9:49 AM, Arthur Zubarev wrote: There are 200+ times more updates and 50x inserts than analytical loads. In Cassandra to just be able to query (in CQL

Re: Indexes Fragmentation

2014-09-30 Thread James Briggs
a-top From: Robert Coli To: "user@cassandra.apache.org" Sent: Monday, September 29, 2014 5:01 PM Subject: Re: Indexes Fragmentation On Sun, Sep 28, 2014 at 9:49 AM, Arthur Zubarev wrote: There are 200+ times more updates and 50x inserts than analytical loads. > >In Cassand

Re: Indexes Fragmentation

2014-09-29 Thread Robert Coli
On Sun, Sep 28, 2014 at 9:49 AM, Arthur Zubarev wrote: > > There are 200+ times more updates and 50x inserts than analytical loads. > In Cassandra to just be able to query (in CQL) on a column I have to have > an index, the question is what tall the fragmentation coming from the > frequent updates

Re: Indexes Fragmentation

2014-09-28 Thread Arthur Zubarev
To: user Sent: Sun, Sep 28, 2014 11:41 am Subject: Re: Indexes Fragmentation It’s always a tradeoff between the level of sophistication of the platform and how much work you want to do in the application itself. But, yes, secondary indexing is always added overhead, and added complexity

Re: Indexes Fragmentation

2014-09-28 Thread Arthur Zubarev
. I doubt there is room for bugs, this is a "by design" application behaviour. Regards, Arthur Original Message From: Hannu Kröger To: user Sent: Sun, Sep 28, 2014 11:30 am Subject: Re: Indexes Fragmentation Hi, I think more information is needed before this quest

Re: Indexes Fragmentation

2014-09-28 Thread Jack Krupansky
Subject: Re: Indexes Fragmentation Thank you Jack, But I am afraid it may be an overhead. Added complexity. /Arthur Original Message From: Jack Krupansky To: user Sent: Sun, Sep 28, 2014 11:03 am Subject: Re: Indexes Fragmentation Take a look at DataStax Enterprise as well

Re: Indexes Fragmentation

2014-09-28 Thread Hannu Kröger
Hi, I think more information is needed before this question can be answered. In many cases you manage the indexes by yourself. If that breaks, then you have a consistency problem or a bug in your own code. Consistency is tunable (trade off with performance and availability) and bugs can be fixed.

Re: Indexes Fragmentation

2014-09-28 Thread Arthur Zubarev
Thank you Jack, But I am afraid it may be an overhead. Added complexity. /Arthur Original Message From: Jack Krupansky To: user Sent: Sun, Sep 28, 2014 11:03 am Subject: Re: Indexes Fragmentation Take a look at DataStax Enterprise as well, with its integrated Solr indexing

Re: Indexes Fragmentation

2014-09-28 Thread Jack Krupansky
Take a look at DataStax Enterprise as well, with its integrated Solr indexing of Cassandra data. -- Jack Krupansky From: Arthur Zubarev Sent: Sunday, September 28, 2014 10:55 AM To: user@cassandra.apache.org Subject: Indexes Fragmentation Hi all: A client on a RDBMS faces quick index fragmen