couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <>
Subject Re: Short keys == faster lookups?
Date Sat, 03 Oct 2009 19:43:27 GMT
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 <> 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

View raw message