From user-return-16959-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Mon Jul 4 06:42:37 2011 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 706A666B9 for ; Mon, 4 Jul 2011 06:42:37 +0000 (UTC) Received: (qmail 53669 invoked by uid 500); 4 Jul 2011 06:42:27 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 53157 invoked by uid 500); 4 Jul 2011 06:42:08 -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 52899 invoked by uid 99); 4 Jul 2011 06:42:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jul 2011 06:42:01 +0000 X-ASF-Spam-Status: No, hits=1.6 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of tmatthewjohn1988@gmail.com designates 209.85.212.52 as permitted sender) Received: from [209.85.212.52] (HELO mail-vw0-f52.google.com) (209.85.212.52) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jul 2011 06:41:55 +0000 Received: by vws16 with SMTP id 16so5095212vws.11 for ; Sun, 03 Jul 2011 23:41:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=q+CSnpGqr5yxxuPhQcr32LeO/uMgSFcedaPMbCBkHRI=; b=IGmI4zlHCwFK01OhaEp4TKv6+caf+31+dR/bgXGzSHB53k4xqX3MPeB4303/xQOvBs iRs66wsiDtLKHk73aLCFbvdcKVaz54tmlQ9bn6BTcPiOTrhP5cccTeBq/wRirtdc9zef 6DlnGXh9IQAdvarqTiXm9EOxdBemlPlPMqLpw= MIME-Version: 1.0 Received: by 10.52.95.194 with SMTP id dm2mr4320922vdb.47.1309761694296; Sun, 03 Jul 2011 23:41:34 -0700 (PDT) Received: by 10.52.169.165 with HTTP; Sun, 3 Jul 2011 23:41:34 -0700 (PDT) In-Reply-To: References: Date: Mon, 4 Jul 2011 12:11:34 +0530 Message-ID: Subject: Re: few doubts From: Matthew John To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=20cf307cff4087687c04a738a86f --20cf307cff4087687c04a738a86f Content-Type: text/plain; charset=ISO-8859-1 Hi all! Thanks a lot for your answers: Take-aways for me: 1) The warm-up does happens in CouchDB too. And the time it takes solely depends on the Hardware. But what I wanted to know is when the data is present in the disk and the Server gets restarted, how does CouchDB perform when compared to MySql in performing the Warm-up (lets define Warm-up as filling the memory with Disk data in a judicial manner). Please throw some light on this. 2) Regarding MR (view), I understand its flexibility is similar to that of any Sql system since the view could be compared to a MySql index. Please let me know if my understanding is not great :) :). Thanks for the quick replies. Great to be part of a very active user-group :) :). Thanks, Matthew On Mon, Jul 4, 2011 at 9:14 AM, Jason Smith wrote: > On Mon, Jul 4, 2011 at 10:11 AM, Matthew John > wrote: > > 2) I understand that all the MR queries (views) to be used in the system > has > > to be coded in the Design document. Does that mean a super-set of all > > possible queries which we might use in the System has to be coded in the > > Design doc? Can this be added on the fly (dynamic ) > > Yes. > > Query CouchDB does this: https://github.com/iriscouch/query_couchdb > > Its goal is to clone the Google App Engine query API. Given a (valid) > query, it determines the appropriate map/reduce and _view query to get > that result. If the map/reduce is not there (HTTP 404), then it will > update the design doc and re-query. > > That project is undocumented, incomplete, and the code is sloppy. > However the idea behind it is very good (if I may). > > As Jens says, in practice, like any production database, you tend to > know all of your important queries at development time. During > run-time, you just fill in the blanks for the query. > > -- > Iris Couch > --20cf307cff4087687c04a738a86f--