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 N.Breunese@vpro.nl designates
 145.58.30.184 as permitted sender)
From: Nils Breunese <N.Breunese@vpro.nl>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Date: Tue, 11 Dec 2012 10:31:56 +0100
Subject: Re: request with OR conditions
Thread-Topic: request with OR conditions
Thread-Index: Ac3Xgly2AbhIcOBGSy+R1GyY4jOAhg==
Message-ID: <102263D3-CB68-40A9-8FB8-5C7BFE78052E@vpro.nl>
References: <20121207063826.GA43521@mail.ximad.com>
 <CAC7vo1D2M_Uykd_D88W=Hnew29+NT98wbfUsBJugdtNdU_qKtA@mail.gmail.com>
 <20121208091738.GA47811@mail.ximad.com>
 <20121208223006.4cdc9525@svilendobrev.com>
In-Reply-To: <20121208223006.4cdc9525@svilendobrev.com>
Accept-Language: nl-NL
Content-Language: en-US
acceptlanguage: nl-NL
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

svilen <az@svilendobrev.com> wrote:

> {keys: list-of-keys} is an OR, not AND - {keys : [1,2]} means give=20
> items with key=3D1 OR key=3D2=20
> (human language is not math - "give me the apple and the orange" is not
> same as "give me the thing that is apple and is orange".
>=20
> so if u normalize your query into OR ( ANDs ), and build n-dimensional
> array-key [tag1,tag2,tag3,tag4,...tagn], u could do it - in
> theory...  it's not dynamic - so n is constant. and u cant filter on
> tag2 without tag1.. sub-keys can only be like key1..keym where m<=3Dn
>=20
> the only other/real way is do n queries for your current OR parts,
> then intersect (AND) in memory. try, it may be faster than the
> sql-joins.

Or take a look at couchdb-lucene which does allow these kinds of queries (a=
nd more): https://github.com/rnewson/couchdb-lucene

Nils.=