[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: [merge-tracking] points of improvement in mergetracking sqlite db design

From: David James <djames_at_collab.net>
Date: 2006-09-11 22:10:47 CEST

On 9/11/06, Daniel Rall <dlr@collab.net> wrote:
> On Thu, 31 Aug 2006, Kamesh Jayachandran wrote:
>
> > Daniel Berlin wrote:
> > >On 8/30/06, Kamesh Jayachandran <kamesh@collab.net> wrote:
> ...
> > >>3. The schema+code change to avoid the 'arithmetic series' of records in
> > >> 'mergeinfo' table as mentioned in point 1.
> > >> (After 20 merges I could see 210 records in my
> > >> 'mergeinfo' table, It goes like this n(n+1)/2. for 1000 '1 merge+1
> > >>commit'
> > >> on a same target lead to (1000*1001/2) 500500 records.
> > >>
> > >>4. The name of the table 'mergeinfo' should rather be
> > >>'mergeinfo_details'
> > >> and the name of the table 'mergeinfo_changed' should be 'mergeinfo'.
> ...
> > >The mergeinfo schema has known N^2 space usage issues. I would
> > >suggest you look at something like the alternative schema posted a
> > >while ago if you want something to work on.
> > >
> > Will look in to that.
>
> I believe Dan is referring to the schema posted by David James.

I posted a proposal for an improved schema in May at
http://svn.haxx.se/dev/archive-2006-05/0061.shtml

What changes need to be made to the above schema to make it work in
practice with the current merge-tracking design? I'd love to hear your
feedback. (Dan? Kamesh?)

Cheers,

David

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Mon Sep 11 22:24:08 2006

This is an archived mail posted to the Subversion Dev mailing list.