Re: Minimizing the `revisions' table.

Greg Stein wrote:

>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.
>
>
Yes we can. We can find the range of indexes where

   " (TxnID, 0.0.0)" <= key < "(TxnID + 1, 0.0.0)"

-- 
Brane Čibej   <brane_at_xbc.nu>   http://www.xbc.nu/brane/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org