couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kimber <mkim...@kana.com>
Subject RE: Am I doing something fundamentally wrong?
Date Thu, 24 May 2012 13:39:03 GMT
I have a compact job set-up to run daily (couch 1.2) but as we don't update or delete anything
i.e. once the docs are uploaded then they aren't touched I suspect it has never run as if
I understand it correctly our docs and views should not need compacting.

However the space I quoted in my original post (which causes an error on this mailing list
but you can find a copy here http://mail-archives.apache.org/mod_mbox/couchdb-user/201205.mbox/%3CA7D50E04F38FD44D9D914F2ABCA592BF2E6E690685@BE259.mail.lan%3E
) the 5.6GB view is the size immediately after it has completed building 9only has 1 key and
3 NVP attributes).

Mike 

-----Original Message-----
From: ziggythehamster@gmail.com [mailto:ziggythehamster@gmail.com] On Behalf Of Keith Gable
Sent: 24 May 2012 13:49
To: user@couchdb.apache.org
Subject: RE: Am I doing something fundamentally wrong?

Regarding the space used... do you compact the database often?
On May 24, 2012 4:47 AM, "Mike Kimber" <mkimber@kana.com> wrote:

> Aurélien,
>
> 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
> this message, sorry !", so there must be something in the e-mail that the
> mailing list system does not like.
>
> In response to your original response " I'm a bit puzzled by the fact that
> your map functions use the document ID". I do this because I load the data
> into Luciddb and this allows me to join between tables. This is not my end
> game this is just a compromise due to the time it takes to generate a view
> 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
> view build takes a very long time, it only uses a single CPU and uses a
> bucket load of space even with compression on (no idea why when it has a
> lot less data than the original)
>
> Thanks
>
> Mike
>
> -----Original Message-----
> From: Aurélien Bénel [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élien
>

Mime
View raw message