RE: Re: `svn log -v' time inefficiencies

Updated idea of what a SQL store might do: (with ideas from Brane)

Add an index to NodeRevision via a new BDB table
(NodeRevisionIndexedbyTxnID or NodeRevisionI1 for short):
Either:
   (TXN_ID, NodeRevisionPK) -> (No data columns)
or:
   TXN_ID -> NodeReiviosnPK (and allow duplicate rows)

Add a DeletedOrRenamed table:
  (NodeRevisionDirectoryPK, EntryName) -> (NodeRevisionEntryPK,
RenameCopyID)
or:
   NodeRevisionDirectoryPK -> (EntryName, NodeRevisionEntryPK,
RenameCopyID) (and allow duplicate rows)

If RenameCopyID is NULL then it's a delete.

Add "Commited at Path" to the NodeRevision skel.

Given the above information it's quite easy to get the appropriate
changes.

Bill

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Fri Jun 14 00:48:15 2002