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 chrisstocktonaz@gmail.com
 designates 209.85.223.171 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;
        b=sCTXqb1Bv0KMyYardSmDCGNT2ijkH3fVWUBrY/x+EYOBAdPZlxWFZZ3Dlro8de2UFr
         /4Rk+MEWFfsGP8aU0XxjNEPBogi5RsvOZUcmBcWM+XxbgTHI+nGkZRmwNfaPlks39wdY
         PnhGZdtYo7N+oc61LRno60iJT4iWEo0FV1m9Q=
MIME-Version: 1.0
In-Reply-To: <C7B1BE15-51F7-4799-85AF-6CFBD1DCB670@gmail.com>
References: <z2re2e02fe1004131021m7f45b3d9wc42a11d2618c54f5@mail.gmail.com>
	 <C7B1BE15-51F7-4799-85AF-6CFBD1DCB670@gmail.com>
Date: Tue, 13 Apr 2010 11:17:26 -0700
Message-ID: <k2we2e02fe1004131117u820a9025tfb2f218bb216af18@mail.gmail.com>
Subject: Re: Views - Finding the column count for a given "table"
From: Chris Stockton <chrisstocktonaz@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello,

On Tue, Apr 13, 2010 at 10:28 AM, J Chris Anderson <jchris@gmail.com> wrote:
>
> This looks right to me.
>
> You might try replacing the reduce function with the simple text:
>
> _count
>
> which will do the equivalent reduce in Erlang (which will be much faster). Can you see if that helps?

Thank you much for your response, your confirmation that my reduce
looked correct led me to check other avenues and solve my issue.

The getCountByTableColumn view works hand and hand with
getByTableColumnValues for sorting. Turns out my substr call was
sometimes being called on NULL in the getByTableColumnValues. This
would raise a exception and fail to index those rows. This happens
very rarely as we do not usually have null rows, since
getByTableColumnValues returned a different number of rows then my
getCountByTableColumn call it made me think the counting was
incorrect. Fun times!

Kind Regards,

-Chris