Have you compacted both the database and the views?
I ran into an issue where even paging through the results of a view
always slowed down substantially when I got to about document number
10000. After compacting the view, the problem went away.
Kevin
On 3/14/2013 9:00 AM, Arne Fischer wrote:
We are using CouchDB as a Database in a Mobile context. Because of this
performance and data size is a problem and very important to us.
We tried writing a filter in erlang within a design element, but sadly we
didn't notice a upgrade in speed. It takes us about 3 minutes to find documents
within a database of 90k elements.
These filters will later be used to replicate the database to a mobile device.
Code samples are in this
http://stackoverflow.com/questions/15388488/very-slow-filters-with-couchdb-even-with-erlang
Stack overflow post.
How is it possible to increase filter speed?
Is it a mistake to write erlang filters within the _design/ documents? If yes
where do you put the filter?
We would really like to use CouchDB more and this is hindering us right now.
kind regards,
Arne Fischer
