Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of elf2001@gmail.com designates
 72.14.220.158 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=urlviXtRYh40Y9OR2Tzifx5Z+mdD4ynm7/Fh996sp+XPYWHF9rXHBNBQLlXdEdR7FA
         wc/wvejTusBOFtReaCMuhPf8tC0qGy7GqwtUxjx3oiNcgJxlFUC0cgjmc1UmADHlVtBN
         eZqkkNehX6nTv1j56WUaScvDG7JaWRZ9dLmyE=
MIME-Version: 1.0
In-Reply-To: <B1A6168A-9F22-432C-9491-3B64CC232FE3@gmail.com>
References: <4a29064f0904190456m124fc8den42fb55fa62c19068@mail.gmail.com>
	 <B1A6168A-9F22-432C-9491-3B64CC232FE3@gmail.com>
Date: Sun, 19 Apr 2009 20:46:45 +0300
Message-ID: <4a29064f0904191046p2e36f65fsee89bc2f45754981@mail.gmail.com>
Subject: Re: Is speed falls on dynamic views?
From: Elf <elf2001@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2009/4/19 Wout Mertens <wout.mertens@gmail.com>:
> On Apr 19, 2009, at 1:56 PM, Elf wrote:
>
>> So, i have something like in view:
>>
>> if (doc.date_check < (new Date().getTime()/1000 - 2*60*60)) {
>> =A0 =A0 emit('not checked', 1);
>> }
>>
>> As I understand, it's impossible to cache this view results, so this
>> view must be recounted on every call.
>> Am i right?
>
> No.
>
> This view will be calculated once and then the result is what it was unti=
l
> the document is changed and the view recalculated.

So, only first view calculating will be correct (new Date() returns
current date) and all next calls to this view will return incorrect
rows (because of outdate new Date() value in a view)?


>> Is there better idea to get document-level locking?
>
> Instead of "moving the view" you should "move the viewer".
>
> You should make a view showing only documents that are being worked on an=
d
> emit the time at which work started. You can then get that view ordered i=
n
> reverse, with the startkey set to to the time before which document
> processing should be retried.

Elegantly, thanks for idea!


--=20
----------------
Best regards
Elf
mailto:elf2001@gmail.com