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 ara.t.howard@gmail.com
 designates 209.85.219.13 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type
         :content-transfer-encoding:mime-version:subject:date:references
         :x-mailer;
        b=C5QP9vbEGcsYNt34PIjP2ipp9a1YdrQfHY3+Fbnj+iLeGdldr9Fr47t3oBFBPWAiUK
         pfwHzlbAYz68YD1/Xhvd/pVPtFidWCdBs/xrvkIJtVk/rAEpDT0M+/Q66aS4P/jk+MBa
         7sTvoS8WJxVO7fwqiQt+nQjycjvYmT6iRE+wU=
Message-Id: <6DCE17DF-FDA8-46E0-B606-826A865212F3@gmail.com>
From: "ara.t.howard" <ara.t.howard@gmail.com>
To: user@couchdb.apache.org
In-Reply-To: <64a10fff0812150946r7ca6ced2pc1776468bc5533a2@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v929.2)
Subject: Re: Multiple search criteria with ranges
Date: Mon, 15 Dec 2008 15:53:08 -0700
References: <12C3EB1F-8F69-4998-BB83-F45564CC9F64@gmail.com>
 <50512BF7-84AA-4870-89E0-35D22B87D2F0@gmail.com>
 <64a10fff0812150946r7ca6ced2pc1776468bc5533a2@mail.gmail.com>


On Dec 15, 2008, at 10:46 AM, Dean Landolt wrote:

> I don't think it's the actual intersection that kills, but the  
> downloading
> and json parsing of what would be megabytes of data (just the docids  
> alone
> for 200k docs would be quite a few mb).

yeah that is a good point.  it's about 1.7 mb per 100k of json ids.   
if the 'client' were actually like a rails instance running on the  
same box or subnet as the db i guess that could work out, but  
otherwise it's a pretty tough sell.  i wonder about doing something  
creative with indexing both an attribute and an id and them limiting  
by start/endkey and docid....  sure seems like this should be solvable.

cheers.

a @ http://codeforpeople.com/
--
we can deny everything, except that we have the possibility of being  
better. simply reflect on that.
h.h. the 14th dalai lama