cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manoj Khangaonkar <khangaon...@gmail.com>
Subject Re: Data model suggestions
Date Thu, 23 Apr 2015 16:20:02 GMT
Hi,

How do you determine if the record is no longer active ? Is it a perioidic
process that goes through every record and checks when the last update
happened ?

regards

On Thu, Apr 23, 2015 at 8:09 AM, Ali Akhtar <ali.rac200@gmail.com> wrote:

> Hey all,
>
> We are working on moving a mysql based application to Cassandra.
>
> The workflow in mysql is this: We have two tables: active and archive .
> Every hour, we pull in data from an external API. The records which are
> active, are kept in 'active' table. Once a record is no longer active, its
> deleted from 'active' and re-inserted into 'archive'
>
> The purpose for that, is because most of the time, queries are only done
> against the active records rather than archived. Therefore keeping the
> active table small may help with faster queries, if it only has to search
> 200k records vs 3 million or more.
>
> Is it advisable to keep the same data model in Cassandra? I'm concerned
> about tombstone issues when records are deleted from active.
>
> Thanks.
>



-- 
http://khangaonkar.blogspot.com/

Mime
View raw message