Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Berkeley DB question

Re: Berkeley DB question

From: <bostic_at_bostic.com>
Date: 2000/06/07
Message-ID: <8hlove$3ij$1@nnrp1.deja.com>#1/1

In article <Pine.LNX.4.10.10006070834400.4288-100000_at_titanic.rtxirl.ie>, Olivier Deme <odeme_at_titanic.rtxirl.ie> wrote:

>

> My question is, if I store 2 entries with the same key that is,
> let's say, 20 bytes, does that mean that the key will be fully
> inserted again, the second time. That is, the total amount of
> space used by the keys for both entries is 40 bytes?

Only a single copy of the key is stored by Berkeley DB, regardless of the number of duplicates.

The upcoming 3.1.XX release of Berkeley DB will offer significantly faster support for large numbers of duplicate records, you will want to upgrade to that release.

Regards,
--keith

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Keith Bostic

Sleepycat Software Inc.         bostic_at_sleepycat.com
394 E. Riding Dr.               +1-978-371-0408
Carlisle, MA 01741-1601         http://www.sleepycat.com


Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US