Return-Path: X-Original-To: notmuch@notmuchmail.org Delivered-To: notmuch@notmuchmail.org Received: from localhost (localhost [127.0.0.1]) by olra.theworths.org (Postfix) with ESMTP id 1CCD5431FB6 for ; Wed, 4 May 2011 19:43:04 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at olra.theworths.org X-Spam-Flag: NO X-Spam-Score: -0.699 X-Spam-Level: X-Spam-Status: No, score=-0.699 tagged_above=-999 required=5 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7] autolearn=disabled Received: from olra.theworths.org ([127.0.0.1]) by localhost (olra.theworths.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aZxUcXyXpl8O for ; Wed, 4 May 2011 19:43:02 -0700 (PDT) Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com [209.85.216.181]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by olra.theworths.org (Postfix) with ESMTPS id D0308431FB5 for ; Wed, 4 May 2011 19:43:01 -0700 (PDT) Received: by qyg14 with SMTP id 14so1449780qyg.5 for ; Wed, 04 May 2011 19:43:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=yWGbIDBI2DTxL/Fe/6iBqlpcUGirZWHwT95J8N5EHEI=; b=mS5QgDIsUk/b/4lYHOQfh9vkJhep2x8M+DTxObGN7VXRQNw4KroQGH5+704Sq0Uluv ESc/fkwN0TTFsWjujbDvbG6vK2NeRlwxxxNFnqXYoKruPS+ayybhnDQRTVASafHOS+c0 IaaHYUFMA8gD83IfVJUrtog9x+IH7dadZcLTs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type :content-transfer-encoding; b=C+UpBpTagBmZ/kvDNNeIVhJX3lden5TeC0OciEe37QfLHijF8fWdrbsh9b2WYFKQqs uB7OX33POCdbUOwpxZC30THZDTALwaGp5B01HCC0exT69l7RlvBxBxedLROviccSq/yp n0vZeGEvBZCAOxtEc/Awcm3fwVDx7l6VpWVx4= MIME-Version: 1.0 Received: by 10.229.251.13 with SMTP id mq13mr1459578qcb.36.1304563380927; Wed, 04 May 2011 19:43:00 -0700 (PDT) Sender: amdragon@gmail.com Received: by 10.229.233.17 with HTTP; Wed, 4 May 2011 19:43:00 -0700 (PDT) In-Reply-To: References: Date: Wed, 4 May 2011 22:43:00 -0400 X-Google-Sender-Auth: 9U9enDeibjEHK4DTpVXmm-umxho Message-ID: Subject: Re: storing From and Subject in xapian From: Austin Clements To: Istvan Marko Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Cc: notmuch@notmuchmail.org X-BeenThere: notmuch@notmuchmail.org X-Mailman-Version: 2.1.13 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 May 2011 02:43:04 -0000 On Wed, May 4, 2011 at 9:48 PM, Austin Clements wrote: > As another data point, with a probably very different configuration (8 > year old P4, new SSD), my test query was 1.9X faster uncached and 1.6X > faster cached. =A0It also produced 60% fewer disk reads. =A0I saw the sam= e > 1% increase in database size. Oops, the email was on an SSD, but the database was on a separate spinning disk. With them both on the SSD, it's 2.1X faster uncached.