How many keys inside a bucket ?

Alexander Sicular siculars at basho.com
Fri Jan 27 03:18:18 EST 2017


Hello Alex,

As long as each bucket does not have its own properties but rather shares one or a handful of bucket types you should be fine and it wouldn't make a difference. 

One way to record data temporally, aka in a time series fashion, from a data model perspective is via a pattern called deterministic materialized keys. You basically record the sensor name (known id) and a base time at some granularity into the key name and push all data captured in that time frame into that key. This works well if you expect to record data at regular intervals. If, however, your data is sparse you'll need some additional model to know when you've recorded data. 

-Alexander 


@siculars
http://siculars.posthaven.com

Sent from my iRotaryPhone

> On Jan 27, 2017, at 14:32, Alex Feng <sweden.feng at gmail.com> wrote:
> 
> Hi Alexander,
> 
> Yes, I should consider the possibility of switching to Riak TS.
> But I guess the question still valid, does it ?  Should I divide millions of keys to different buckets, does it make any difference in performance, memory, space ?
> 
> 
> Br,
> Alex
> 
> 2017-01-27 2:50 GMT+01:00 Alexander Sicular <siculars at basho.com>:
>> Hi, you should consider using Riak TS for this use case.
>> 
>> -Alexander
>> 
>> 
>> @siculars
>> http://siculars.posthaven.com
>> 
>> Sent from my iRotaryPhone
>> 
>> > On Jan 27, 2017, at 01:54, Alex Feng <sweden.feng at gmail.com> wrote:
>> >
>> > Hi,
>> >
>> > I am wondering if there are some best practice or recommendation for how many keys inside a single bucket?
>> >
>> > Let's say I have some sensors reporting data every 5 seconds, I can put all these data under one single bucket, or I can dynamically generate a bucket every day.
>> >
>> > My question is,   is there any performance difference for "insert", "query" etc. between them?  for example,  1 million records under one bucket and 10k records under 100 buckets ?
>> >
>> > Thank you.
>> >
>> > Br,
>> > Alex
>> > _______________________________________________
>> > riak-users mailing list
>> > riak-users at lists.basho.com
>> > http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
> 
> _______________________________________________
> riak-users mailing list
> riak-users at lists.basho.com
> http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.basho.com/pipermail/riak-users_lists.basho.com/attachments/20170127/44070e3d/attachment-0002.html>


More information about the riak-users mailing list