From user-return-20943-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Thu May 24 11:08:15 2012 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 496059BB2 for ; Thu, 24 May 2012 11:08:15 +0000 (UTC) Received: (qmail 90871 invoked by uid 500); 24 May 2012 11:08:13 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 90630 invoked by uid 500); 24 May 2012 11:08:13 -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 90606 invoked by uid 99); 24 May 2012 11:08:12 -0000 Received: from minotaur.apache.org (HELO minotaur.apache.org) (140.211.11.9) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 May 2012 11:08:12 +0000 Received: from localhost (HELO mail-gg0-f180.google.com) (127.0.0.1) (smtp-auth username rnewson, mechanism plain) by minotaur.apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 May 2012 11:08:12 +0000 Received: by ggnf1 with SMTP id f1so9258596ggn.11 for ; Thu, 24 May 2012 04:08:11 -0700 (PDT) MIME-Version: 1.0 Received: by 10.50.173.40 with SMTP id bh8mr15953516igc.65.1337857691441; Thu, 24 May 2012 04:08:11 -0700 (PDT) Received: by 10.42.110.76 with HTTP; Thu, 24 May 2012 04:08:11 -0700 (PDT) In-Reply-To: References: <08E52809-C962-4E9C-AFB8-397EA201580E@utt.fr> Date: Thu, 24 May 2012 12:08:11 +0100 Message-ID: Subject: Re: Am I doing something fundamentally wrong? From: Robert Newson To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Or use a list function; http://wiki.apache.org/couchdb/Formatting_with_Show_and_List You can use one with _all_docs and you can POST an array of ids too. http://wiki.apache.org/couchdb/HTTP_view_API > Since 0.9 you can also issue POST requests to views where you can send th= e following JSON structure in the body: > {"keys": ["key1", "key2", ...]} B. On 24 May 2012 11:58, Mike Kimber wrote: > Looking at Show documentation and running a quick test I don't think this= helps as Show has to be referenced by a doc._id or view key. If these aren= 't provided it returns null. This makes sense as its for generation of a ht= ml, XML page/doc etc. > > So I'd have to =A0get a list of all doc ID's I want and then call the sho= w function for each and to get a filtered list I need a view. > > Mike > > -----Original Message----- > From: Mike Kimber [mailto:mkimber@kana.com] > Sent: 24 May 2012 10:47 > To: user@couchdb.apache.org > Subject: RE: Am I doing something fundamentally wrong? > > Aur=E9lien, > > Thanks for the response and apologies I didn't get a notification (e-mail= ) of my original post (or the 2nd one) or your response. When I look at my = original post in Google Reader is has "An error occurred while fetching thi= s message, sorry !", so there must be something in the e-mail that the mail= ing list system does not like. > > In response to your original response " I'm a bit puzzled by the fact tha= t your map functions use the document ID". I do this because I load the dat= a into Luciddb and this allows me to join between tables. This is not my en= d game this is just a compromise due to the time it takes to generate a vie= w and my need to play/discover with the data. > > I will look at show to see if It helps, however it does not really answer= my original questions and it does not remove the more general issue that v= iew build takes a very long time, it only uses a single CPU and uses a buck= et load of space even with compression on (no idea why when it has a lot le= ss data than the original) > > Thanks > > Mike > > -----Original Message----- > From: Aur=E9lien B=E9nel [mailto:aurelien.benel@utt.fr] > Sent: 24 May 2012 07:40 > To: user@couchdb.apache.org > Subject: Re: Am I doing something fundamentally wrong? > > Hi Mike, > >> Didn't seem to get there first time so having another go > > As I wrote in my earlier post, the use of 'map' functions in both of your= examples is overkill. > Use 'show' functions instead.They won't require an index to be built. > > > Regards, > > Aur=E9lien