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 marcello.nuccio@gmail.com
 designates 209.85.220.180 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=TRChcXwmhCn7Bkzp9QbefHYhntmBL0+0qZH4hOvPo4HD2vEesh8HMUO5i8eFd8cTth
         E4kA48d1AsYQ9LOc0mbGYatlCDmx4zy1uOAlC/cQnCH2Ny2qjAO7rjlbnlxAfSXxQXT9
         HUBlAOzgxSIjd36KWkcWy/GoMxMzB2cksvjws=
MIME-Version: 1.0
In-Reply-To: <BANLkTikab3+j12W8eoPX1QBXR7LWe-KmBQ@mail.gmail.com>
References: <BANLkTikab3+j12W8eoPX1QBXR7LWe-KmBQ@mail.gmail.com>
Date: Thu, 16 Jun 2011 07:40:00 +0200
Message-ID: <BANLkTin6uAhN3Bc6Z6CaLKcXr=UPKaHsxQ@mail.gmail.com>
Subject: Re: view index generation for single document and bulk documents
From: Marcello Nuccio <marcello.nuccio@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Yogesh,
I cannot answer your questions, but I think you should repeat your
tests with CouchDB-1.1 and querying the view with `stale=3Dupdate_after`
parameter.

Read http://docs.couchbase.org/couchdb-release-1.1/index.html#coudhdb-relea=
se-1.1-updateafter
for more information.

Bye,
 Marcello

2011/6/16 Yogesh Khambia <ykhambia@gmail.com>:
> Hi all,
>
> Currently, I am doing performance tests with database in CouchDB 1.0.1,
> where a script is continuously writing single documents to the CouchDB
> database.
> I had the issue of the user being penalized for reading the view in Couch=
DB
> database, by updating the view indexes.To improve on the latency for the
> view index generation, I wrote a function which generates the view indexe=
s
> for each new update made to the database.
> The latency for view index creation has been improved. However, I read fr=
om
> the FAQ on the CouchDB wiki that "The reason not to integrate each doc as=
 it
> comes in is that it is horribly inefficient and CouchDB is designed to do
> view index updates very fast, so batching is a good idea."
> It will be really helpful if somebody can answer me on following:
>
> - If =A0view index generation for each new single document insert is not =
a
> good approach?
>
> - How does the single document insert and bulk document insert affect the
> CouchDB view generation, where:
>
> =A0 1. =A0a daemon script updates view index for each new document insert=
.
> =A0 2. =A0a daemon script updates view index for bulk document
>
> Thank you.
>
>
> --
> Best Regards,
> Yogesh Khambia
> Postgraduate Design Engineer
> Mobile: +31 626 217 381
> Email: y.khambia@tue.nl
>