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/%[email protected]%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: [email protected] [mailto:[email protected]] On Behalf Of Keith Gable Sent: 24 May 2012 13:49 To: [email protected] 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" <[email protected]> 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:[email protected]] > Sent: 24 May 2012 07:40 > To: [email protected] > 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 >
