Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 19267 invoked from network); 16 Dec 2008 19:14:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Dec 2008 19:14:29 -0000 Received: (qmail 76973 invoked by uid 500); 16 Dec 2008 19:14:37 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 76929 invoked by uid 500); 16 Dec 2008 19:14:37 -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 76887 invoked by uid 99); 16 Dec 2008 19:14:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Dec 2008 11:14:37 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ian.connor@gmail.com designates 209.85.219.13 as permitted sender) Received: from [209.85.219.13] (HELO mail-ew0-f13.google.com) (209.85.219.13) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Dec 2008 19:14:22 +0000 Received: by ewy6 with SMTP id 6so4198395ewy.11 for ; Tue, 16 Dec 2008 11:14:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=fbo1u12Rb5oyN0xmmMpuZ/EDvYBN1sciAWDY+4VwaI4=; b=TbwddsgoIbULoD+JSPNlkLrXBZ4BfHjZE37w7bn5Kz3lmwTzQLkTazX+capvc3WxOl DT7UNvGzvpqfC3k6uw9IhU2zt1UoX0e4xOTzPOhl1jOywYckIXqiUedkqXFK3yMOwZzA LmTBKalli25m0tMJSegN1473OuM7WSwd+HfY0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=ABqtm5xeIDdEDqooyY5/TZuSxR0D+uw70eLdvHiwtyT85VP45MENsbbBfbtyz6vkY4 pA4kuMfrAE8XdRg4svC6W/q0gIYJTRIxIyH4VJqJgqhh8quykV6Xf+j/bOzw1bpkym1G JmJVVxW+NlaoIpS/aUpUYupeKVwF4iNbgPG5Y= Received: by 10.210.70.14 with SMTP id s14mr7489797eba.42.1229454842148; Tue, 16 Dec 2008 11:14:02 -0800 (PST) Received: by 10.210.135.14 with HTTP; Tue, 16 Dec 2008 11:14:02 -0800 (PST) Message-ID: Date: Tue, 16 Dec 2008 14:14:02 -0500 From: "Ian Connor" To: user@couchdb.apache.org Subject: Is there a modified table or quick way to get all that is modified since a given date? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6756_22488894.1229454842155" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_6756_22488894.1229454842155 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I am trying to see all the documents modified since a given date - or is sequence number a better idea? Ideally, I want to update a solr/lucene index and then keep the modified date or last state that the index was updated. Then on a regular (hourly or daily) basis, update the index from the changes in couchdb. One way, would be to know the last update time from the index and get all changes since that time. However, I noticed that there is this sequence number kept per database. I assume this might help in some way with replication in a similar way the modified table works in Lotus Notes. Is this true, is there a view/query I could run to get all documents touched after a given sequence number? -- Regards, Ian Connor CTO - pubget.com ------=_Part_6756_22488894.1229454842155--