incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kimber <>
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
) the 5.6GB view is the size immediately after it has completed building 9only has 1 key and
3 NVP attributes).


-----Original Message-----
From: [] On Behalf Of Keith Gable
Sent: 24 May 2012 13:49
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" <> 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 []
> Sent: 24 May 2012 07:40
> To:
> 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

View raw message