Hi Alain, Thanks for your response and the links.
I've also checked "Time series data model and tombstones". Is it safe to use TWCS in C* 3.9? Thanks in advance. On 31-01-2017 11:27, Alain RODRIGUEZ wrote: > > Is there a overhead using line by line option or wasted disk space? > > There is a very recent topic about that in the mailing list, look for > "Time series data model and tombstones". I believe DuyHai answer your > question there with more details :). > > *tl;dr:* > > Yes, if you know the TTL in advance, and it is fixed, you might want > to go with the table option instead of adding the TTL in each insert. > Also you might want consider using TWCS compaction strategy. > > Here are some blogposts my coworkers recently wrote about TWCS, it > might be useful: > > http://thelastpickle.com/blog/2016/12/08/TWCS-part1.html > http://thelastpickle.com/blog/2017/01/10/twcs-part2.html > > C*heers, > ----------------------- > Alain Rodriguez - @arodream - al...@thelastpickle.com > <mailto:al...@thelastpickle.com> > France > > The Last Pickle - Apache Cassandra Consulting > http://www.thelastpickle.com > > > > 2017-01-31 10:43 GMT+01:00 Cogumelos Maravilha > <cogumelosmaravi...@sapo.pt <mailto:cogumelosmaravi...@sapo.pt>>: > > Hi I'm just wondering what option is fastest: > > Global:***create table xxx (.....****|AND |**|default_time_to_live = > |**|XXX|**|;|**||****and******UPDATE xxx USING TTL XXX;* > > Line by line: > > *INSERT INTO xxx (...****USING TTL xxx;* > > Is there a overhead using line by line option or wasted disk space? > > Thanks in advance. > >
