From user-return-21080-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Tue Jun 5 09:20:39 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3919CC562 for ; Tue, 5 Jun 2012 09:20:39 +0000 (UTC) Received: (qmail 92530 invoked by uid 500); 5 Jun 2012 09:20:37 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 92501 invoked by uid 500); 5 Jun 2012 09:20:37 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 92481 invoked by uid 99); 5 Jun 2012 09:20:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2012 09:20:37 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of simon@cloudant.com designates 209.85.214.52 as permitted sender) Received: from [209.85.214.52] (HELO mail-bk0-f52.google.com) (209.85.214.52) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2012 09:20:27 +0000 Received: by bkcjc3 with SMTP id jc3so5428974bkc.11 for ; Tue, 05 Jun 2012 02:20:07 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=date:from:to:message-id:in-reply-to:references:subject:x-mailer :mime-version:content-type:x-gm-message-state; bh=9WEuA5JV9cpUWfyW+O01ZGdfsFqVyLePByBRUtG1rdg=; b=JvCC7KcsQPwMj7idDbCJg4IzJ+Mc138qPnC9N2Xx8RTf6IPpzh6DN/3ZHXvSRyWoK0 PIgJe+8RI8RgFYrU+yNIPvlAm27mKsdfcNKa1pEsjrvvKloumKNeKkrA3BczK1f50fNz Yx7xpworhUGC/hRqTK6Kuy6tbpIpVkFHPSXMNjAVQ7CGLhnb0BAa1vToNU14XZRLVIp2 XhDNP1COgVHcaLgJ3srA2d1PIdJpVw2dB8OzVhPtZm80fkuhv36Nad9YBOar2gGz4m1r YY/qXk7DUlbg6JCZ9K8cixrYJl2X1tbZdNuj4y8Uf/QJ05gsyrgSgaAIDe5CkCPO1cNA j7XA== Received: by 10.205.126.14 with SMTP id gu14mr8730943bkc.137.1338888007167; Tue, 05 Jun 2012 02:20:07 -0700 (PDT) Received: from [172.16.17.193] (pd95c9d95.dip0.t-ipconnect.de. [217.92.157.149]) by mx.google.com with ESMTPS id n17sm1095243bkw.5.2012.06.05.02.20.06 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 05 Jun 2012 02:20:06 -0700 (PDT) Date: Tue, 5 Jun 2012 11:20:07 +0200 From: Simon Metson To: user@couchdb.apache.org Message-ID: In-Reply-To: <4C727F57-569A-4619-A969-DC8AC665B41B@rhus.winterroot.net> References: <4C727F57-569A-4619-A969-DC8AC665B41B@rhus.winterroot.net> Subject: Re: geocouch with 3rd dimension X-Mailer: sparrow 1.6 (build 1081.27) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="4fcdcf47_7644a45c_11e68" X-Gm-Message-State: ALoCoQkC4XudHVADxiB/1ymMeofCaxkRVOBXCC+3ELbZCoo8epykD2g8LPF4Ry/gpLyG0K6MNVci --4fcdcf47_7644a45c_11e68 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline You could use couchdb-lucene to do an N dimensional query. Filtering stuff out in a list is generally not very efficient because the result isn't cached for subsequent queries, and if your filter is sparse you may find queries are slow as you do a lot of work before being able to respond to the client. Cheers Simon On Saturday, 2 June 2012 at 00:47, Matthew wrote: > Greetings! > > What's the usual way to handle spatial queries where you also want to filter results by an additional dimension? geocouch is only 2d, so is doing so in a the spatial list function the only option? Since this means touching every record in the result set, are there any performance implications? > > Thanks, > Matthew > > --4fcdcf47_7644a45c_11e68--