On Tue, Nov 18, 2014 at 8:38 AM, Ahmy Yulrizka <yulri...@gmail.com> wrote:
> > > 1. Is this a proper use of a counter > It seems reasonable. > 2. would the delete operation has impact on performance ? > Depending on how you query the data, no. If you restrict the query to not cover times where you have deleted the counters, the only impact should be to compactions and repairs. > 3. Is it better if I don't use counter ? use an integer column type and > use the TTL ? Are you getting multiple updates to the value from different sources? If so, you need to use a counter (or pick a master somewhere to coordinate updates). If you're only going to update each counter from a single source and you always have the full count (not just a delta), normal ints are a better choice. -- Tyler Hobbs DataStax <http://datastax.com/>
