Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of kiril@open-net.biz designates
 188.138.38.206 as permitted sender)
Message-ID: <54FDA211.2030408@open-net.biz>
Date: Mon, 09 Mar 2015 15:37:21 +0200
From: Kiril Stankov <kiril@open-net.biz>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: How to get number of normal (non-design) documents in CouchDB?
References: <20150301171158.0fac2fe7@mainframe.vimsonnet.se>
	<71A31F88-1BFA-4046-8967-1F748D3E9557@apache.org>
	<20150302123034.6df4e534@mainframe.vimsonnet.se>
	<CAHdjipK5ETDoYOjLh-O+zb0sxy+JLc9V5Qq_Xr9EMr4XZ=4cKA@mail.gmail.com>
	<D2C23F56-3FB7-4298-BBD5-601BA9A8D1A0@apache.org>
	<54FD986A.9040401@open-net.biz>	<54FD9979.4060008@open-net.biz>
 <CAHdjipJsaRgvUTKbh+VBWBscBJ58ns=VDhR6vrB9E2g9m3KH+w@mail.gmail.com>
In-Reply-To: 
 <CAHdjipJsaRgvUTKbh+VBWBscBJ58ns=VDhR6vrB9E2g9m3KH+w@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------070706090401050604070609"

--------------070706090401050604070609
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Thanks a lot!
I like the second one... :)

------------------------------------------------------------------------
*With best regards,*
Kiril Stankov,

On 09-Mar-15 3:23 PM, Alexander Shorin wrote:
> No need to check for doc._id in a view since views doesn't indexed
> design documents by default. Just use a single emit(null, null) with
> _count to reduce index size.
> Another way to to make a two queries: GET /db and GET
> /db/_all_docs?startkey="_design"&endkey="_design0" and apply some math
> on total documents count and amount of returned design docs.
>
>
> --
> ,,,^..^,,,
>
>
> On Mon, Mar 9, 2015 at 4:00 PM, Kiril Stankov <kiril@open-net.biz> wrote:
>> Well,
>>
>> I think I figured it out. I can create a view and check for doc._id not
>> starting with '_design' and then use _count.
>> But as I expect to have thousands  of documents I'd rather not create a view
>> just for counting docs...
>> Anyone with better idea?
>>
>> ------------------------------------------------------------------------
>> *With best regards,*
>> Kiril Stankov
>>
>> On 09-Mar-15 2:56 PM, Kiril Stankov wrote:
>>> Hi,
>>> anyone aware of a way to get count of non-design documents in CouchDB?
>>> Thanks in advance!
>>> ------------------------------------------------------------------------
>>> *With best regards,*
>>> Kiril Stankov
>>>
>>>
>>>


--------------070706090401050604070609--