couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From svilen>
Subject Re: Update handler is very slow
Date Wed, 06 Mar 2013 11:33:05 GMT
+1. i'd like to know also about update_handlers as i may get into such
situation soon.

not an answer:
if you sure your transformation is correct, my lame take would be: 
don't do anything.
4doc/s, 12000/hour - so by tomorrow it would be done.

of course, no harm to find/learn - e.g. u may need to rerun it again.. 


On Wed, 6 Mar 2013 12:06:41 +0100
Daniel Gonzalez <> wrote:

> Hi,
> We have a problem in our data: we have been inconsistent in one of our
> fields, and we have named it in different ways. Besides, in some
> places we have used int, in other places string. I have created an
> update handler to correct this situation, and I am running it for our
> 100 thousand documents database, by doing PUT requests, as explained
> What I am doing is:
>    1. get affected documents with a view
>    2. call the update handler.
> And this is running over an ssh tunnel.
> My problem is that this is veeeery slow. Currently I am running at 4
> docs/s. Is this normal?
> I could do this locally (no ssh tunnel), but I guess things would not
> improve much, since the data being transferred is not that big (no
> include_docs, and the view emits very litte information). I have the
> impression that the bottleneck is couchdb itself: the update handler
> is just that slow.
> Am I right about this? Is there a way to speed this up?
> Thanks,
> Daniel

View raw message