Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
MIME-Version: 1.0
In-Reply-To: <60C7D1C6-DE78-4798-9E8F-AB03E2F25C7D@poplatek.fi>
References: <265B0514-CB04-4C5A-8824-77B3008F4D47@poplatek.fi>
	<CABvT1DH=g=MV-BzLMogVLastc=MJtLo6EbLt_mNQsKB=1ygLTw@mail.gmail.com>
	<60C7D1C6-DE78-4798-9E8F-AB03E2F25C7D@poplatek.fi>
Date: Mon, 11 Mar 2013 16:20:53 -0500
Message-ID: 
 <CABvT1DG6QOyGqFBZD_RyrMvogczgnCxpw1OMsYUNRf7y3FVXNw@mail.gmail.com>
Subject: Re: Very slow queries to view in design doc
From: Robert Newson <rnewson@apache.org>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Can you access /_log on the server? might have information.

Does the custom reduce function actually reduce (that is, return a
much smaller value than the input 'values' array)?

B.

On 11 March 2013 03:27, Sami Sierla <sami.sierla@poplatek.fi> wrote:
> Hi,
>
> There is custom reduce function in this view but result is same even if r=
educe=3Dfalse. Could this have something to do with running out of file des=
criptors (I unfortunately don't have sufficient user rights to check this o=
n server). Issue began after we added two databases (unrelated to this view=
) to CouchDB (both have continuous replication to standby server).
>
> Best,
> Sami
>
> On Mar 8, 2013, at 4:20 PM, Robert Newson <rnewson@apache.org> wrote:
>
>> Do you have a custom reduce function? Are the keys/values in that view
>> very large?
>>
>> On 8 March 2013 08:18, Sami Sierla <sami.sierla@poplatek.fi> wrote:
>>> Hi,
>>>
>>> We are having odd issue with CouchDB 1.2.0 view queries - queries to on=
e particular view are very slow (tens of seconds with limit=3D1) but querie=
s to other views in the same design doc perform as they should. Issue goes =
away if we restart CouchDB but comes back after few hours. Views are period=
ically refreshed so there are no indexing blocking the query. The setup we =
have consists of about ten CouchDB databases on active db server (RHEL 5) a=
nd second standby server with continuous CouchDB pull replication. Same vie=
w query works fine on the standby server that has no other processes runnin=
g.
>>>
>>> Any ideas what could cause this?
>>>
>>> Best,
>>> Sami Sierla
>