Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.217.220 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=IEEqKBqKw4MZbl3xytoAc2YN6+YhM2EhD9hB3wnL3b5KQyIIrIxoHvwI7s3bqYZox9
         TEiOn0BG3ekyEpn4xyTMk0HfbP+Ql0rxzJqyIjlH/wUY1wfW1jhGmDIuv7nxZiWr6Gdb
         S8WexYs4AuU4958uz2DHuvk5pR7EV1URdfk0w=
MIME-Version: 1.0
In-Reply-To: <C6809374-BA73-4F3A-BAD1-2D364CD0370D@mac.com>
References: <C6809374-BA73-4F3A-BAD1-2D364CD0370D@mac.com>
Date: Sat, 3 Oct 2009 15:43:27 -0400
Message-ID: <e2111bbb0910031243o1b2eababo8ee1d04f7eb44322@mail.gmail.com>
Subject: Re: Short keys == faster lookups?
From: Paul Davis <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Technically speaking you could probably engineer keys to exhibit bad
collation behavior, but that'd take some thought. Something like 1KiB
or larger keys with long identical prefixes.

That said, measure twice, code once. I've never heard any numbers on it.

Paul Davis

On Sat, Oct 3, 2009 at 9:29 AM, Per Ejeklint <ejeklint@mac.com> wrote:
> Please excuse a silly question from a newbie. I have a db that grows pretty
> fast (data measurements done every minute all year around). I wonder what I
> save if I mangle keys to be as short as possible. Like instead of calling
> things "temp_outside" I rename them to "t_o" or something like it. The size
> of the db will of course shrink, but will it do anything for indexing/lookup
> speed when I search in the db?
>
> /Per
>