From: Andreas Ericsson Date: Wed, 05 Sep 2007 14:51:26 GMT Subject: Re: Git's database structure Message-ID: <46DEC26E.7030809@op5.se> In-Reply-To: <9e4733910709050641j34d58683ra72caa52c56cdf0f@mail.gmail.com> Jon Smirl wrote: > > The path name field needs to be moved back into the blobs to support > alternative indexes. For example I want an index on the Signed-off-by > field. I use this index to give me the SHAs for the blobs > Signed-off-by a particular person. In the current design I have no way > of recovering the path name for these blobs other than a brute force > search following every path looking for the right SHA. > Ah, there we go. A use-case at last :) So now we have a concrete problem that we can formulate thus: "How can one create a database listing the relationship between 'signers' and blobs?" So the second question: Do you seriously argue that git should take a huge performance loss on its common operations to accommodate a need that I suspect very few people have? -- Andreas Ericsson andreas.ericsson@op5.se OP5 AB www.op5.se Tel: +46 8-230225 Fax: +46 8-230231