couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Kuprianov <andrey.koupria...@gmail.com>
Subject Distinct values with range
Date Mon, 15 Apr 2013 01:37:27 GMT
Hi guys,

Just for the sake of a debate. Here's the question. There are transactions.
Among all other attributes there's timestamp (when transaction was made; in
seconds) and a country name  (from where the transaction was made). So, for
instance,

{
    . . . .
    "timestamp": 1332806400
    "country_name": "Australia",
    . . . .
}

Question is: how does one get unique / distinct country names in between
dates? For example, give me all country names in between 10-Jul-2010 and
21-Jan-2013.

My solution was to write a custom reduce function and set
reduce_limit=false, so that i can enumerate all countries without hitting
the overflow exception. It works great! However, such solutions are frowned
upon by everyone around. Has anyone a better idea on how to tackle this
efficiently?

    Andrey

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message