Re: Minimizing the `revisions' table.

On Fri, Jun 14, 2002 at 01:10:11PM -0700, Bill Tutt wrote:
> > From: cmpilato@collab.net [mailto:cmpilato@collab.net]
>...
> > Oh, "replace = delete + add", where modify means "text or prop
> > changes". Sorry for the ambiguitiy.
>
> Replace is unnecessary if the primary key of the table is:
> (TxnID, NodeRevisionID)

BDB doesn't do multi-column primary keys. Well, it *can*, but you could not
come along later and ask for all rows related to TxnID.

>...
> Let client applications detect replaces and renames. :)

Yah.

> Otherwise, if the key was (TxnID, Path) we'd need two NodeRevisionIDs in
> the skel. One for the deleted one, and one for the added one. (since
> they have differing NodeIDs)

Might be needed to get what we need, tho.

Cheers,
-g

-- 
Greg Stein, http://www.lyra.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org