Re: Minimizing the `revisions' table.

On Fri, Jun 14, 2002 at 02:33:45PM -0500, cmpilato@collab.net wrote:
>...
> CHANGES (a new table, duplicately keyed on Transaction Ids)
> - a "changes" header
> - the changed node revision id
> - the filesystem path of the changed node revision id
> - the kind of change: added, deleted, replaced or modified

Ah. This scales *way* better (hadn't thought about scaling in my earlier
response). You can just add rows rather than keeping a big glom in memory.

How do you define replaced vs. modified? AFAIK, we never "modify".

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