From user-return-10151-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Mon Apr 19 11:43:58 2010 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 14852 invoked from network); 19 Apr 2010 11:43:58 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 19 Apr 2010 11:43:58 -0000 Received: (qmail 40242 invoked by uid 500); 19 Apr 2010 11:43:57 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 40182 invoked by uid 500); 19 Apr 2010 11:43:57 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 40174 invoked by uid 99); 19 Apr 2010 11:43:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Apr 2010 11:43:56 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of manokaran@gmail.com designates 209.85.160.52 as permitted sender) Received: from [209.85.160.52] (HELO mail-pw0-f52.google.com) (209.85.160.52) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Apr 2010 11:43:48 +0000 Received: by pwi1 with SMTP id 1so3017315pwi.11 for ; Mon, 19 Apr 2010 04:43:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:content-type; bh=uHrpaxszDn/7lLVBjjnwA0k85ihl5ctzQJ8sKfP1X1w=; b=EtuaLwwXnbXQBMnDD18KJokMdbqpwRmilIBvqoFrIO+mNDz4HemozlzN2EavOe+65k /NfOaMDAncSIa+PgKzKdVp/7YpmTFWlBXI4bEpK7EL42ANBGA7lTdFaf18Sa/ZgkYX2u OJsDREMwKweJXbcZGkHGddK0qx/caycbWxMEk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=GQNxtc6k2uds8+R4949TYjz5ZK5szkiHASR7zXxRFA7xbEnWGTurLBDdyfXKMnOjWt i9on1VFjNgED+Q+1osZZR7uV0wPOOBiIt0vKHtKa9hZUKOrf/EuIE+OT4JugxO/aQ8KS d36jDvQWCF+tlr2UynfQ58YkQgx1OffVDIhK4= MIME-Version: 1.0 Received: by 10.143.158.1 with HTTP; Mon, 19 Apr 2010 04:43:27 -0700 (PDT) In-Reply-To: References: <9B0D55A7F3222047AE1B5E9189587C1C0D6566D349@dionysos.vervis.ws> <6F1B8C1D-8EAE-4E3E-8225-40462B5BA791@googlemail.com> <9B0D55A7F3222047AE1B5E9189587C1C0D6566D37C@dionysos.vervis.ws> Date: Mon, 19 Apr 2010 17:13:27 +0530 Received: by 10.143.179.2 with SMTP id g2mr2026517wfp.161.1271677407052; Mon, 19 Apr 2010 04:43:27 -0700 (PDT) Message-ID: Subject: Re: Map function to find docs in time interval From: Manokaran K To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=000e0cd5d1c61dc52604849578da X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd5d1c61dc52604849578da Content-Type: text/plain; charset=ISO-8859-1 On Mon, Apr 19, 2010 at 4:58 PM, Manokaran K wrote: > Following will create a lot of rows but the key size would be small: > > from_time = x milliseconds > till_time = y milliseconds > > for(var i=from_time; i<=till_time; i += 60000){ //for each visitor, a row > for every minute he/she was inside. > emit(i, doc._id); > } > > Then you can query with the time (in millisecs) as the key to get all > visitors. > Sorry. Instead of key, you'll have to use startkey and endkey regds, mano --000e0cd5d1c61dc52604849578da--