Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EF9F699FE for ; Wed, 2 Nov 2011 20:35:34 +0000 (UTC) Received: (qmail 36142 invoked by uid 500); 2 Nov 2011 20:35:33 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 36101 invoked by uid 500); 2 Nov 2011 20:35:33 -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 36093 invoked by uid 99); 2 Nov 2011 20:35:33 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2011 20:35:33 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of ryan.ramage@gmail.com designates 209.85.212.52 as permitted sender) Received: from [209.85.212.52] (HELO mail-vw0-f52.google.com) (209.85.212.52) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2011 20:35:28 +0000 Received: by vws10 with SMTP id 10so818545vws.11 for ; Wed, 02 Nov 2011 13:35:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=j906lCrvfvAtsk5cHxxPUE4MSHiFKobrtbQOc83qgxs=; b=FgK1KM5rArEFY+e16BeWzaLfFSt7C1dHGVhuUyZnZkG6cAEPZnE9wA8xD/9kVttZ6d KQTHtNmEMwaVCA0SEpsg0OUg1oxfUBdZFpQk4VwydbvQo1jX/SX7rjjA8FNIsd/GK6Ch +YdMD+AHAlmq9EDZC5TUQI3gXnZ5zRSSbmGoE= MIME-Version: 1.0 Received: by 10.52.115.74 with SMTP id jm10mr6228677vdb.40.1320266108145; Wed, 02 Nov 2011 13:35:08 -0700 (PDT) Received: by 10.220.193.75 with HTTP; Wed, 2 Nov 2011 13:35:08 -0700 (PDT) In-Reply-To: <7F5F85A9-D5B6-4779-A523-ECD6E90CBDD0@couchbase.com> References: <7F5F85A9-D5B6-4779-A523-ECD6E90CBDD0@couchbase.com> Date: Wed, 2 Nov 2011 14:35:08 -0600 Message-ID: Subject: Re: Reconciling Data From: Ryan Ramage To: user@couchdb.apache.org Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable You might want to have your other data source more sleep-y (no joke) http://syncable.org/ On Wed, Nov 2, 2011 at 1:49 PM, Jens Alfke wrote: > > On Nov 2, 2011, at 9:20 AM, Henri van den Bulk wrote: > >> I'm in the process of writing an external program in Java that reconcile= s data in CouchDB to a source system. One of the basic parts is to determin= e what data needs to be removed from CouchDB. The good thing is that the Id= s in CouchDB are the same as the Ids in the source system. However, some in= itial test seem that the process is very slow in determining what needs to = be removed. > > It=92s inevitably going to be inefficient to have to fetch _all_ the doc = IDs from CouchDB and _all_ the IDs from the other system and then scan them= looking for differences. > > Instead, is there a way you can query the other system to find out which = docs have been removed since the last time you synced? > > =97Jens --=20 Twitter: @eckoit