1 Return-Path: <amdragon@gmail.com>
\r
2 X-Original-To: notmuch@notmuchmail.org
\r
3 Delivered-To: notmuch@notmuchmail.org
\r
4 Received: from localhost (localhost [127.0.0.1])
\r
5 by olra.theworths.org (Postfix) with ESMTP id 1CCD5431FB6
\r
6 for <notmuch@notmuchmail.org>; Wed, 4 May 2011 19:43:04 -0700 (PDT)
\r
7 X-Virus-Scanned: Debian amavisd-new at olra.theworths.org
\r
11 X-Spam-Status: No, score=-0.699 tagged_above=-999 required=5
\r
12 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, FREEMAIL_FROM=0.001,
\r
13 RCVD_IN_DNSWL_LOW=-0.7] autolearn=disabled
\r
14 Received: from olra.theworths.org ([127.0.0.1])
\r
15 by localhost (olra.theworths.org [127.0.0.1]) (amavisd-new, port 10024)
\r
16 with ESMTP id aZxUcXyXpl8O for <notmuch@notmuchmail.org>;
\r
17 Wed, 4 May 2011 19:43:02 -0700 (PDT)
\r
18 Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com
\r
19 [209.85.216.181]) (using TLSv1 with cipher RC4-SHA (128/128 bits))
\r
20 (No client certificate requested)
\r
21 by olra.theworths.org (Postfix) with ESMTPS id D0308431FB5
\r
22 for <notmuch@notmuchmail.org>; Wed, 4 May 2011 19:43:01 -0700 (PDT)
\r
23 Received: by qyg14 with SMTP id 14so1449780qyg.5
\r
24 for <notmuch@notmuchmail.org>; Wed, 04 May 2011 19:43:01 -0700 (PDT)
\r
25 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
\r
26 h=domainkey-signature:mime-version:sender:in-reply-to:references:date
\r
27 :x-google-sender-auth:message-id:subject:from:to:cc:content-type
\r
28 :content-transfer-encoding;
\r
29 bh=yWGbIDBI2DTxL/Fe/6iBqlpcUGirZWHwT95J8N5EHEI=;
\r
30 b=mS5QgDIsUk/b/4lYHOQfh9vkJhep2x8M+DTxObGN7VXRQNw4KroQGH5+704Sq0Uluv
\r
31 ESc/fkwN0TTFsWjujbDvbG6vK2NeRlwxxxNFnqXYoKruPS+ayybhnDQRTVASafHOS+c0
\r
32 IaaHYUFMA8gD83IfVJUrtog9x+IH7dadZcLTs=
\r
33 DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
\r
34 h=mime-version:sender:in-reply-to:references:date
\r
35 :x-google-sender-auth:message-id:subject:from:to:cc:content-type
\r
36 :content-transfer-encoding;
\r
37 b=C+UpBpTagBmZ/kvDNNeIVhJX3lden5TeC0OciEe37QfLHijF8fWdrbsh9b2WYFKQqs
\r
38 uB7OX33POCdbUOwpxZC30THZDTALwaGp5B01HCC0exT69l7RlvBxBxedLROviccSq/yp
\r
39 n0vZeGEvBZCAOxtEc/Awcm3fwVDx7l6VpWVx4=
\r
41 Received: by 10.229.251.13 with SMTP id mq13mr1459578qcb.36.1304563380927;
\r
42 Wed, 04 May 2011 19:43:00 -0700 (PDT)
\r
43 Sender: amdragon@gmail.com
\r
44 Received: by 10.229.233.17 with HTTP; Wed, 4 May 2011 19:43:00 -0700 (PDT)
\r
45 In-Reply-To: <BANLkTimvs8ttQCL0AK9UrjcxxgaeqQ9fSg@mail.gmail.com>
\r
46 References: <m3sjsv2kw2.fsf@zsu.kismala.com>
\r
47 <BANLkTimvs8ttQCL0AK9UrjcxxgaeqQ9fSg@mail.gmail.com>
\r
48 Date: Wed, 4 May 2011 22:43:00 -0400
\r
49 X-Google-Sender-Auth: 9U9enDeibjEHK4DTpVXmm-umxho
\r
50 Message-ID: <BANLkTin1OC-Xz5mwcV3awJVg3ZogUjihPQ@mail.gmail.com>
\r
51 Subject: Re: storing From and Subject in xapian
\r
52 From: Austin Clements <amdragon@mit.edu>
\r
53 To: Istvan Marko <notmuch@kismala.com>
\r
54 Content-Type: text/plain; charset=ISO-8859-1
\r
55 Content-Transfer-Encoding: quoted-printable
\r
56 Cc: notmuch@notmuchmail.org
\r
57 X-BeenThere: notmuch@notmuchmail.org
\r
58 X-Mailman-Version: 2.1.13
\r
60 List-Id: "Use and development of the notmuch mail system."
\r
61 <notmuch.notmuchmail.org>
\r
62 List-Unsubscribe: <http://notmuchmail.org/mailman/options/notmuch>,
\r
63 <mailto:notmuch-request@notmuchmail.org?subject=unsubscribe>
\r
64 List-Archive: <http://notmuchmail.org/pipermail/notmuch>
\r
65 List-Post: <mailto:notmuch@notmuchmail.org>
\r
66 List-Help: <mailto:notmuch-request@notmuchmail.org?subject=help>
\r
67 List-Subscribe: <http://notmuchmail.org/mailman/listinfo/notmuch>,
\r
68 <mailto:notmuch-request@notmuchmail.org?subject=subscribe>
\r
69 X-List-Received-Date: Thu, 05 May 2011 02:43:04 -0000
\r
71 On Wed, May 4, 2011 at 9:48 PM, Austin Clements <amdragon@mit.edu> wrote:
\r
72 > As another data point, with a probably very different configuration (8
\r
73 > year old P4, new SSD), my test query was 1.9X faster uncached and 1.6X
\r
74 > faster cached. =A0It also produced 60% fewer disk reads. =A0I saw the sam=
\r
76 > 1% increase in database size.
\r
78 Oops, the email was on an SSD, but the database was on a separate
\r
79 spinning disk. With them both on the SSD, it's 2.1X faster uncached.
\r