incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randall Leeds <randall.le...@gmail.com>
Subject Re: How to speedup view generation?
Date Thu, 04 Nov 2010 21:27:06 GMT
I'm more interested to know if compacting the database before building
the view helps.

If you have many document updates it could be that the density of new
changes is higher at the end of the database file. In other words, the
I/O bottleneck isn't caused by a large file but but maybe reading more
information. Much of the early parts of the by-sequence btree may have
been overwritten by new changes and therefore ignored in view
generation.

For example, if you have a database of 1 document with 1 million
changes, you would expect the view generation to roll through the
first 999k changes very quickly.

-Randall

On Thu, Nov 4, 2010 at 04:07, cdr53x <cdr53x@free.fr> wrote:
> On 11/04/2010 11:55 AM, Nils Breunese wrote:
>>
>> Also after compaction?
>>
>
> Yes after compaction. ;)
>
>
>
>
>
>

Mime
View raw message