Re: Forcing document reindex

2010-11-18 Thread Nicolas Jessus
Ryan Ramage writes: > > Thinking about this, you don't have to get all the database. If you > have the set of keys you are interested in for all the docs eg > [clientName, dateMP1, dateM1] > Thank you for your kind heart and desire to help, Ryan; I'm however afraid you misunderstood the proble

Re: Forcing document reindex

2010-11-17 Thread Ryan Ramage
Thinking about this, you don't have to get all the database. If you have the set of keys you are interested in for all the docs eg [clientName, dateMP1, dateM1] 1. create a design doc '_design/report' 2. create a view that for all types you want, eg 'by_id' and emit(doc._id, doc) 3. create a

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
> What about a list function? I really don't see how that would work, except by getting most of the database to be returned to the list function and doing set manipulation there...

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
> you can only emit a result from the map function if key elements to be used > are in the document currently being indexed. Well, yes, that's the problem I'm trying to get around somehow. > have to use a list or one of the lucene projects to combine views together. > or figure out a way to put a

Re: Forcing document reindex

2010-11-17 Thread Nicholas Orr
On Thu, Nov 18, 2010 at 5:00 AM, Nicolas Jessus wrote: > > Naively, the key should be something like [clientName, dateMP1, dateM1], or > maybe [clientName] and a value of [dateMP1, dateM1]. There can be hundreds > of > thousands of meetings. The problem is to generate the key triplet when > there'

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
Hello Cliff, > I am not sure if I fully understand your use case (however it does sound > intriguing and unusual). Sorry, I'll try to be clearer. I should have taken a real case to start with, I just didn't want to be necessarily verbose (failed!). Consider 5 types of documents: type: Meeting

Re: Forcing document reindex

2010-11-17 Thread Ryan Ramage
What about a list function? You can access the request to get query parameters (eg id needed for the report?) and then you can iterate through the docs and build up your relationship. I dont know how fast it will be with the number of docs you have, but it will be liner time (order n). http://gu

Re: Forcing document reindex

2010-11-17 Thread Cliff Williams
Nicolas, I am not sure if I fully understand your use case (however it does sound intriguing and unusual). A couple of things stick out in your commentary; "The data is only weakly relational." "DB updates are relatively few" I assume that you are getting data out of your legacy MySQL system

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
All right; no one should like what they're going to read. I have a medium-sized MySQL system, which translates to a Couch with about a million documents of about 20 types. The system would really benefit from a schema-free design. The data is only weakly relational. Couch would fit really well, en

Re: Forcing document reindex

2010-11-17 Thread Jan Lehnardt
On 17 Nov 2010, at 15:16, Nicolas Jessus wrote: >> No. But storing the document with no changes will do the trick. Of course, > CouchDB will update the _rev field >> in the process. > > That would probably cause concurrency problems with legitimate updates. Shame. > That would be very useful fun

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
> No. But storing the document with no changes will do the trick. Of course, CouchDB will update the _rev field > in the process. That would probably cause concurrency problems with legitimate updates. Shame. That would be very useful functionality. Thanks for the help, anyway Nic

Re: Forcing document reindex

2010-11-17 Thread Jan Lehnardt
On 17 Nov 2010, at 14:34, Nicolas Jessus wrote: >> If you make a change to your view functions (a whitespace change will do) >> and query the view again, it'll be rebuilt. >> >> Please don't abuse your couch too much :) >> >> Cheers >> Jan > > > Hello Jan, > Thank you for the answer. I'd just

Re: Forcing document reindex

2010-11-17 Thread Nicolas Jessus
> If you make a change to your view functions (a whitespace change will do) > and query the view again, it'll be rebuilt. > > Please don't abuse your couch too much :) > > Cheers > Jan Hello Jan, Thank you for the answer. I'd just like to avoid rebuilding entire views, and have the benefit of r

Re: Forcing document reindex

2010-11-17 Thread Jan Lehnardt
Ni Nicolas, On 17 Nov 2010, at 14:00, Nicolas Jessus wrote: > Is there a way to force a document reindex, like is triggered by an update, > without actually doing the update? > > I am trying to do unspeakable things to Couch, but ones that would be very > useful (and inefficient, but that woul

Forcing document reindex

2010-11-17 Thread Nicolas Jessus
Is there a way to force a document reindex, like is triggered by an update, without actually doing the update? I am trying to do unspeakable things to Couch, but ones that would be very useful (and inefficient, but that would be ok). I'll tell if it works :) Thanks, Nic