On September 23, 2013 12:41:04 PM Matt Black wrote:
> Hey list.
> 
> A quick question on best practices really:
> 
>    - Should I use a bin index with ISO8601 format?
>    - Or should I use an Unix timestamp as an integer index?
>    - Is there likely to be a performance difference? (There will certainly
>    be storage size difference).
>    - Has anyone had an specific success with either approach?
> 
> Thanks
> Matt

Hi Matt,

For my own project, I needed a way to fetch the set of items that needed 
updating.  I just stored a unix timestamp (as an integer) when there were to 
be updated, and then do a 2i range query from the oldest time possible to the 
current time.  It works like a charm for me.

I don't have this project working at scale right now, so in terms of speed I'm 
not sure.  Though I'd think doing range queries against the ISO8601 would be 
more difficult.
-- 
Matthew

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
riak-users mailing list
[email protected]
http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com

Reply via email to