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

Re: SQL backend database scheme

From: Jan Horák <horak.honza_at_gmail.com>
Date: Wed, 31 Mar 2010 17:20:04 +0200

30.3.2010 13:55, Philipp Marek wrote:
> Hello Jan!
>
> On Montag, 29. März 2010, Jan Horák wrote:
>
>> I've prepared a database scheme of the upcoming MySQL backend, it is
>> avaible at:
>> http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_mysql_des
>> ign_v1.png
>>
> I looked at that, and I'd like to post two wishes:
> * Please provide representations with a SHA1 (or similar) field;
> then it's possible to split blocks on manber-borders, to save
> space.
>
Thank you for respond, this is definitely a good point, I will involve it.
> * Furthermore, how about allowing the plain data to reside in files?
> Would make the database much smaller, and then these data blocks
> could possibly be shared among multiple repositories.
> (Really easy, too, if they're named by their SHA1, for example).
> That should allow for zero-copy IO, too (at least for sending data).
>
>
The question is, how much faster it would be.. I would like to make a
simple test to simulate this soon and estimate the percentage difference..

Another point is a simple backup of the SQL database, using an existed
global backup system in a company, which is one of the main benefits of
the SQL backend. Would the external plain data be a problem for global
backup or not?
> Regards,
>
> Phil
>
Received on 2010-03-31 17:20:41 CEST

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